From: Hannu Krosing <hannu@trust.ee>
To: Jose' Soares Da Silva <sferac@bo.nettuno.it>
Cc: pgsql-interfaces@postgreSQL.org, Byron Nikolaidis <byronn@insightdist.com>
Subject: Re: [INTERFACES] Access'97 and ODBC
Date: Tue, 28 Apr 1998 17:51:02 +0300
Message-ID: <3545ECD6.5615904D@sid.trust.ee> (raw)
References: <Pine.LNX.3.96.980427141308.1975A-100000@proxy.bazzanese.com>
Jose' Soares Da Silva wrote:
>
> I have a table with field1 DATE and field2 TIMESTAMP. If I insert data
> into these fields, field2 looks OK, but Access97 show me a strange
> date on field1.
>
> This is Access97 output:
> field1: 27/7/99
> field2: 1998-04-27 12:20:21+02
>
> This is psql output:
> Field | Value
> -- RECORD 0 --
> field1| 1998-04-27
> field2| 1998-04-27 12:20:21+02
> ----
> PS: My DateStyle is setting to 'ISO'
You should set it to 'US' when using Insight ODBC drivers.
It should affect the output in no way, but the driver expects it from
the backend in US format. As this is a per-connection setting it can
safely be set from the driver at startup without affecting other
connections.
There has been some discussion about 'fixing' it and making the
driver recognize other date formats. That would be IMHO unnecessary.
It should be enough just to do "SET DateStyle TO 'US';" at startup.
This can be currently done by setting some registry entries, but
this should really be just a part of driver startup.
Hannu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: hannu@trust.ee, sferac@bo.nettuno.it, byronn@insightdist.com
Subject: Re: [INTERFACES] Access'97 and ODBC
In-Reply-To: <3545ECD6.5615904D@sid.trust.ee>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox