Received: from fondos.net ([212.80.170.130]) by postgresql.org (8.11.3/8.11.1) with SMTP id f64Ecma32859 for ; Wed, 4 Jul 2001 10:38:48 -0400 (EDT) (envelope-from oserra@fondos.net) Received: (qmail 31787 invoked from network); 4 Jul 2001 14:40:40 -0000 Received: from unknown (HELO orcas) (172.26.66.10) by svr2.fondos.net with SMTP; 4 Jul 2001 14:40:40 -0000 From: "Oscar Serrano" To: "Cedar Cox" , Subject: RE: non-us datestyle Date: Wed, 4 Jul 2001 16:41:38 +0200 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal In-Reply-To: X-Archive-Number: 200107/19 X-Sequence-Number: 1772 > -----Mensaje original----- > De: pgsql-interfaces-owner@postgresql.org > [mailto:pgsql-interfaces-owner@postgresql.org]En nombre de Cedar Cox > Enviado el: miercoles, 04 de julio de 2001 14:53 > Para: pgsql-interfaces@postgresql.org > Asunto: [INTERFACES] non-us datestyle > > > > Is there a way to set the default date style to non-US (European)? I > didn't see any compile or run time options, just per connection options. > (pg v1.7) > > -Cedar Well I'm not sure if you are asking for this but... If you define the shell variable PGDATESTYLE to, for example, SQL, all date are returned like this: dd/mm/yyyy There are serveral values you can assign to PGDATESTYLE. You can execute, prior to a query this sentence: SET DATESTYLE TO SQL > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >