Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5MCeia50188 for ; Fri, 22 Jun 2001 08:40:44 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from mail.scania.com (ns.scania.com [138.106.100.100]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5L95sa56550 for ; Thu, 21 Jun 2001 05:05:55 -0400 (EDT) (envelope-from roelof.sondaar@wmdata.nl) Received: from virscan3.Scania.se (virscan3.scania.se [138.106.11.202]) by mail.scania.com (Pro-8.9.3/Pro-8.9.3) with SMTP id LAA33492 for ; Thu, 21 Jun 2001 11:05:51 +0200 Received: FROM n08606.scania.se BY virscan3.Scania.se ; Thu Jun 21 11:05:50 2001 +0200 Received: from bushmill.scania.se (bushmill.scania.se [138.106.13.95]) by n08606.scania.se (Switch-2.0.3/Switch-2.0.3) with ESMTP id f5L95oP34442 for ; Thu, 21 Jun 2001 11:05:50 +0200 Received: from wmdata.nl (WS7098 [139.122.161.65]) by bushmill.scania.se with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id MALHN2H5; Thu, 21 Jun 2001 11:05:49 +0200 Message-ID: <3B31B90D.A5EA90F8@wmdata.nl> Date: Thu, 21 Jun 2001 11:06:21 +0200 From: Roelof Sondaar Organization: WM-data Zwolle B.V. X-Mailer: Mozilla 4.7 [nl] (WinNT; U) X-Accept-Language: nl MIME-Version: 1.0 To: "Mailing List, PostgreSQL-sql" Subject: Re: set datestyle to European PROBLEM References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200106/360 X-Sequence-Number: 3647 Hello Alessandro, The manual I have says the following about Date/Time Styles: - 4 styles (ISO-8601, SQL, Postgres, German) The one which resembles your layout is German. I looked it up in Bruce Momjians book. Best regards, Roelof Alessandro Rossi schreef: > > I have the defaul installation of postgres 7.0.3 and on another machine > 7.1.2 on redhat 7.1 > > I cannont get the date in correct form: > > dbme=# select data_ar from equipment limit 5; > data_ar > ------------ > 2001-11-05 > 2001-05-17 > 2001-05-28 > 2001-05-28 > 2001-05-22 > (5 rows) > > then: > > dbme=# set datestyle to European; > SET VARIABLE > > dbme=# select data_ar from equipment limit 5; > data_ar > ------------ > 2001-11-05 > 2001-05-17 > 2001-05-28 > 2001-05-28 > 2001-05-22 > (5 rows) > > Is this a bug ? > > I think i should get dd-mm-yyy date format and not yyyy-mm-dd > > Is postgres using ISO date format as default ? > > Thanks > > Alex > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster -- Roelof Sondaar WM-data Zwolle B.V. Russenweg 5 P O Box 391 8000 AJ ZWOLLE The Netherlands E-mail: roelof.sondaar@wmdata.nl Telephone:+31(0)384 977 366 Fax: +31(0)384 977 600 WWW: www.wmdata.nl ******************************************************* Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of WM-data Zwolle B.V. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of this email is strictly prohibited. If you have received this email in error please notify WM-data Zwolle B.V. Helpdesk by telephone on +31(0)384 977 319 *******************************************************