Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id LAA09703 for ; Mon, 27 Apr 1998 11:14:10 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.8.5/8.8.5) with UUCP id KAA27373 for pgsql-interfaces@postgreSQL.org; Mon, 27 Apr 1998 10:45:01 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!byronn using -f Received: by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA37648; Mon, 27 Apr 1998 10:38:15 -0400 Received: from [3.0.0.50] by ceodev (AIX 4.1/UCB 5.64/4.03) id AA63068; Mon, 27 Apr 1998 10:36:37 -0400 Message-Id: <354498D0.72729A92@insightdist.com> Date: Mon, 27 Apr 1998 10:40:17 -0400 From: Byron Nikolaidis X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: "Jose' Soares Da Silva" Cc: "Julia A.Case" , "Jose' Soares Da Silva" , interfaces postgres Subject: Re: [INTERFACES] Access'97 and ODBC References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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'