Date: Fri, 16 Mar 2001 19:51:24 +0000
From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: pgsql-interfaces@postgresql.org
Subject: Access datetime oddities
Message-ID: <20010316195124.P20615@quartz.newn.cam.ac.uk>
Reply-To: prlw1@cam.ac.uk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2i

I am trying to get M$ Access and postgresql to talk via an odbc driver. Queries
involving "datetime" on M$ Access seem to include things like

'#15:10:00#'

which allegedly means "what's in quotes is a datetime" and

{t "timeslice"}

where timeslice in the postgresql table which is "linked" is a timestamp
with time zone and apparently means CAST (timeslice AS TIME), but of course
M$ Access doesn't seem to know about CAST().

Having looked at 4.7 of ansi-iso-9075-2-1999, there is no mention of # nor
{t ...}, {d ...}. Where do these come from? Is this something to do with the
odbc in between? (they appear in the odbc.log)

Basically it means that queries such as

select ... where cast(timeslice as time)>'15:10:00'

can't be done...

Thoughts?

Cheers,

Patrick