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

From: "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it>
To: Walt Bigelow <walt(at)stimpy(dot)com>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] problem with the 'date' data type and msaccess95 :(
Date: 1998-06-02 11:42:43
Message-ID: Pine.LNX.3.96.980602113643.576A-100000@proxy.bazzanese.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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'

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Konstantin S. Kuznetsov 1998-06-03 02:26:14 Need ODBC driver
Previous Message Herouth Maoz 1998-06-02 07:54:03 Re: [SQL] soundex more or less exact