Received: from sd.tpf.co.jp (sd.tpf.co.jp [210.161.239.34]) by postgresql.org (8.11.3/8.11.1) with SMTP id f64NEPa01100 for ; Wed, 4 Jul 2001 19:14:25 -0400 (EDT) (envelope-from Inoue@tpf.co.jp) Received: (qmail 31982 invoked from network); 4 Jul 2001 23:14:21 -0000 Received: from unknown (HELO viscomail.tpf.co.jp) (100.0.0.108) by sd2.tpf-fw-c.co.jp with SMTP; 4 Jul 2001 23:14:21 -0000 Received: from tpf.co.jp ([126.0.1.68]) by viscomail.tpf.co.jp (8.8.8+Sun/8.8.8) with ESMTP id IAA07077; Thu, 5 Jul 2001 08:14:19 +0900 (JST) Message-ID: <3B43A396.80E29B14@tpf.co.jp> Date: Thu, 05 Jul 2001 08:15:34 +0900 From: Hiroshi Inoue X-Mailer: Mozilla 4.73 [ja] (Windows NT 5.0; U) X-Accept-Language: ja MIME-Version: 1.0 To: Tom Lane CC: Cedar Cox , pgsql-interfaces@postgresql.org Subject: Re: non-us datestyle References: <27753.994262166@sss.pgh.pa.us> Content-Type: text/plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200107/26 X-Sequence-Number: 1779 Tom Lane wrote: > > Cedar Cox writes: > > Is there a way to set the default date style to non-US (European)? > > You can set PGDATESTYLE in the postmaster's environment, I think. > > This should be a GUC variable (hence settable in postgresql.conf) > but isn't yet. > psqlodbc driver seems to set the DateStyle for itself in interfaces/odbc/connection.c. /* Set the Datestyle to the format the driver expects it to be in */ result = SQLExecDirect(hstmt, "set DateStyle to 'ISO'", SQL_NTS); regards, Hiroshi Inoue