you can try
psql>SET DATESTYLE TO ISO/SQL/Postgres
ISO yyyy-mm-dd
SQL mm/dd/yyyy
Postgres Wed Dec 17 07:37:16 1997
Nizomi
----- Original Message -----
Sent: Thursday, April 11, 2002 2:04 PM
Subject: [SQL] Date format
Hi,
I try to set up PG7.1.3
The date format now is yyyy-mm-dd
How can I start it in date format mm-dd-yyyy?
in posgresql file I have:
.......-p /usr/bin/postmaster start -o -i > dev/null 2>...........
Thanks in advance!