Skip site navigation (1) Skip section navigation (2)

Re: non-us datestyle

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Cedar Cox <cedarc(at)visionforisrael(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: non-us datestyle
Date: 2001-07-04 23:15:34
Message-ID: 3B43A396.80E29B14@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-odbc
Tom Lane wrote:
> 
> Cedar Cox <cedarc(at)visionforisrael(dot)com> 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

In response to

pgsql-odbc by date

Next:From: Cedar CoxDate: 2001-07-05 08:34:43
Subject: Re: non-us datestyle
Previous:From: Oscar SerranoDate: 2001-07-04 16:43:36
Subject: RE: non-us datestyle

pgsql-interfaces by date

Next:From: Sudheer PalapparambilDate: 2001-07-05 06:44:32
Subject: PL/PGSQL
Previous:From: NTB Technical SupportDate: 2001-07-04 17:14:22
Subject: ADO and ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group