Received: from proxy.bazzanese.com (sferac@ip223.tol11.interbusiness.it [195.120.106.223]) by hub.org (8.8.8/8.7.5) with ESMTP id FAA10446 for ; Tue, 2 Jun 1998 05:50:44 -0400 (EDT) Received: from localhost (sferac@localhost) by proxy.bazzanese.com (8.8.8/8.8.8/Debian/GNU) with SMTP id LAA00593; Tue, 2 Jun 1998 11:42:44 GMT Date: Tue, 2 Jun 1998 11:42:43 +0000 (UTC) From: "Jose' Soares Da Silva" X-Sender: sferac@proxy.bazzanese.com To: Walt Bigelow cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] problem with the 'date' data type and msaccess95 :( In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII On Mon, 1 Jun 1998, Walt Bigelow wrote: > Hello, > > I've looked around a bit and I'm not sure if it has been asked before, but > I am using posgreSQL 6.3.2 and the ODBC driver postODBC 2.10.0004 and > microsoft access 95. > > I transferred all my tables into the Sql server, and all is okay except > that access does not handel the date type for some reason. I create a > table like follows: > > CREATE TABLE tbldate (date date); > > Then insert a record: > > INSERT INTO tbldate (date) VALUES ('11/10/1998'); > > then a select returns: > > SELECT * from tbldate; > > 11-10-1998 Try psqlodbc v06.30.0243 at: (http://www.insightdist.com/psqlodbc). Jose'