Received: from smtp.dnet.net.id (smtp.dnet.net.id [202.148.1.21]) by postgresql.org (Postfix) with SMTP id BB954475A17 for ; Thu, 11 Apr 2002 03:18:59 -0400 (EDT) Received: (qmail 10642 invoked from network); 11 Apr 2002 14:18:47 +0700 Received: from nizomi.dnet.net.id (HELO ocemz) (202.148.1.41) by smtp.dnet.net.id with SMTP; 11 Apr 2002 14:18:47 +0700 Message-ID: <001d01c1e129$4e65fce0$290194ca@dnet.net.id> From: "Tubagus Nizomi" To: References: <023001c1e127$282e9480$7201a8c0@dmhi.ct.ro> Subject: Re: Date format Date: Thu, 11 Apr 2002 14:20:06 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001A_01C1E163.FAB592A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200204/129 X-Sequence-Number: 7394 This is a multi-part message in MIME format. ------=_NextPart_000_001A_01C1E163.FAB592A0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=20 Nizomi ----- Original Message -----=20 From: cristi69=20 To: pgsql-sql@postgresql.org=20 Sent: Thursday, April 11, 2002 2:04 PM Subject: [SQL] Date format Hi, I try to set up PG7.1.3=20 The date format now is yyyy-mm-dd=20 How can I start it in date format mm-dd-yyyy? in posgresql file I have:=20 .......-p /usr/bin/postmaster start -o -i > dev/null 2>........... =20=20=20 Thanks in advance! ------=_NextPart_000_001A_01C1E163.FAB592A0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
you can try
 
psql>SET DATESTYLE TO=20 ISO/SQL/Postgres
 
ISO        &= nbsp;=20 yyyy-mm-dd
SQL        = =20 mm/dd/yyyy
Postgres  Wed Dec 17 07:37:16 1997=20
 
Nizomi
----- Original Message -----
Fro= m:=20 cristi= 69=20
To: pgsql-sql@postgresql.org
Sent: Thursday, April 11, 2002 2:0= 4=20 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: <= /DIV>
.......-p /usr/bin/postmaster start -o -= i >=20 dev/null 2>...........
 
Thanks in=20 advance!
------=_NextPart_000_001A_01C1E163.FAB592A0--