Re: [SQL] problem with the 'date' data type and msaccess95 :(

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'