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)