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'