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' !!!!!!!!!!!!!!!!!!!!!!!!!!!
> For other dates the function works well !!

I have 7.4.2 and it works well:

maciej@matylda:~$ psql template1
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
        \h for help with SQL commands
        \? for help on internal slash commands
        \g or terminate with semicolon to execute query
        \q to quit

template1=# SELECT to_char('2005-03-27'::date,'DD/MM/YYYY');
   to_char
------------
  27/03/2005
(1 row)