Re: M$-Access'97 and TIMESTAMPs

Byron Nikolaidis <byronn@insightdist.com>

From: Byron Nikolaidis <byronn@insightdist.com>
To: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>
Cc: interfaces postgres <pgsql-interfaces@PostgreSQL.org>
Date: 1998-06-09T13:16:13Z
Lists: pgsql-hackers

Jose' Soares Da Silva wrote:

> Hi, all!
>
> I created a table with a TIMESTAMP data type to use with M$-Access, because
> Access uses such field to control concurrent access on records.
> But I have a problem M$-Access doesn't recognize a TIMESTAMP type, it see
> such fields as "text" instead of "date/time".
> Is there a way to make Access recognize TIMESTAMPs ?
>                                                            Thanks, Jose'

 I could add TimeStamp as a supported data type of the odbc driver.  Currently,
'abstime' is supported but not 'timestamp'.

Byron