Re: Bug in function to_char() !!

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(at)zorbla(dot)de http://r.zorbla.de/
-------------
"A radioactive cat has eighteen half-lives."