Horton

Re: [INTERFACES] Access'97 and ODBC

jose' soares <sferac@bo.nettuno.it>

View thread
From: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
To: "Julia A.Case" <julie@hub.org>
Cc: "Jose' Soares Da Silva" <sferac@proxy.bazzanese.com>, interfaces postgres <pgsql-interfaces@postgreSQL.org>
Date: 1998-04-27T14:25:11Z
Lists: pgsql-hackers 
On Fri, 24 Apr 1998, Julia A.Case wrote:

> 	Please see the Insight Dist site for a newer source and binary
> distribution of the ODBC driver
> 	
> 	http://www.insightdist.com/psqlodbc
> 
> Julie

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'