Re: Bug in function to_char() !! - Mailing list pgsql-general

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."