Najib Abi Fadel wrote:
> Hi, i am using PostgreSQL 7.3.2
>
> there's a bug for the date '2005-03-27' !!!!!!!!!!!!!!!!!!!!!!!!!!!
I think you should replace or clean your keyboard. At least one key
seems to be sticky.
> SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
> to_char
> ------------
> 26/03/2005
> (1 row)
No problem with 7.2.1 and 7.4.1. (don't have a 7.3.2 around).
Both work correctly:
dirk=> SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
to_char
------------
27/03/2005
(1 row)
--
D i r k F "o r s t e r l i n g
r@zorbla.de http://r.zorbla.de/
-------------
"A radioactive cat has eighteen half-lives."