From: Byron Nikolaidis <byronn@insightdist.com>
To: Jose' Soares Da Silva <sferac@bo.nettuno.it>
Cc: Julia A.Case <julie@hub.org>
Cc: Jose' Soares Da Silva <sferac@proxy.bazzanese.com>
Cc: interfaces postgres <pgsql-interfaces@postgreSQL.org>
Subject: Re: [INTERFACES] Access'97 and ODBC
Date: Mon, 27 Apr 1998 10:40:17 -0400
Message-ID: <354498D0.72729A92@insightdist.com> (raw)
References: <Pine.LNX.3.96.980427141308.1975A-100000@proxy.bazzanese.com>
Hello,
The ODBC driver can not yet handle multiple datestyle formats. Currently,
it expects dates to be in US format. There will be a future option that
allows you to configure that for the driver or per datasource.
Byron
Jose' Soares Da Silva wrote:
> Thanks Julie. Now it works, but now I have a little problem about
> date formats.
> 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'
> Jose'
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: byronn@insightdist.com, sferac@bo.nettuno.it, julie@hub.org, sferac@proxy.bazzanese.com
Subject: Re: [INTERFACES] Access'97 and ODBC
In-Reply-To: <354498D0.72729A92@insightdist.com>
* 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