From: Patrick Welche <prlw1@newn.cam.ac.uk>
To: pgsql-interfaces@postgresql.org
Subject: Access datetime oddities
Date: Fri, 16 Mar 2001 19:51:24 +0000
Message-ID: <20010316195124.P20615@quartz.newn.cam.ac.uk> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: prlw1@newn.cam.ac.uk
Subject: Re: Access datetime oddities
In-Reply-To: <20010316195124.P20615@quartz.newn.cam.ac.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox