Postgres Pro
Downloads
Home   >   mailing lists

Thread: Date format

Date format

From
"cristi69"
Date:
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!

Re: Date format

From
"Tubagus Nizomi"
Date:
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
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!