Re: Date format

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 -----
From: cristi69
To: pgsql-sql(at)postgresql(dot)org
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!