Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4MEdPA88523 for ; Tue, 22 May 2001 10:39:25 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from smtp.dnet.net.id (engine9.dnet.net.id [202.148.1.21]) by postgresql.org (8.11.3/8.11.1) with SMTP id f4L2uqA55349 for ; Sun, 20 May 2001 22:56:52 -0400 (EDT) (envelope-from nizomi@dnet.net.id) Received: (qmail 14192 invoked from network); 21 May 2001 09:45:34 +0700 Received: from nizomi.dnet.net.id (HELO ocemz) (nizomi@202.148.1.41) by engine9.dnet.net.id with SMTP; 21 May 2001 09:45:34 +0700 From: Tubagus Nizomi Date: Mon, 21 May 2001 09:56:57 +0700 X-Mailer: KMail [version 1.1.99] Content-Type: text/plain; charset="iso-8859-1" To: pgsql-sql@postgresql.org Subject: Set Datestyle MIME-Version: 1.0 Message-Id: <01052109565701.01337@ocemz> Content-Transfer-Encoding: 8bit X-Archive-Number: 200105/240 X-Sequence-Number: 3057 Hallo, i have postgres 7.1 in Radhat 6.5 the Datestype default is ISO format where is change default Datestyle to Postgres format ?? i used Set Datestyle to postgres in plsql test#>select now() now ------------------------ 2001-05-21 09:55:36+07 test#>set datestyle to postgres; SET VARIABLE test#>select now(); now ------------------------------- Mon May 21 09:56:19 2001 JAVT but when i reconnect to plsql the datestype ISO again Help me plz Nizomi