Postgres Pro
Downloads
Home   >   mailing lists

Re: Date format - Mailing list pgsql-sql

From Tubagus Nizomi
Subject Re: Date format
Date
Msg-id 001d01c1e129$4e65fce0$290194ca@dnet.net.id
Whole thread Raw
In response to Date format  ("cristi69" <cristiv69@yahoo.com>)
List pgsql-sql
Tree view
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!

pgsql-sql by date:

Previous
From: "cristi69"
Date:
Subject: Date format
Next
From: "Richard Ellerbrock"
Date:
Subject: REPOST: Trouble with SQL conversion