Access datetime oddities

From: Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Access datetime oddities
Date: 2001-03-16 19:51:24
Message-ID: 20010316195124.P20615@quartz.newn.cam.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

Browse pgsql-interfaces by date

  From Date Subject
Next Message Creager, Robert S 2001-03-17 01:45:40 Problem building PL/Perl
Previous Message Tom Lane 2001-03-15 15:50:12 Re: Big trouble with libpq++