Interesting question. It makes me wonder, is ODBC supposed to be a smart
pipe or a dumb pipe.
So I ask, it the timestamp being sent, a simple one, with no indication
The postgreSQL has a syntax for timestamps with timezones
hh:mm:ss+/-hh:mm eg (10:30:21-08:00, 09:35:17+05:00). see PostgreSQL
User's guide in the documentation as PDF - just look up datatypes Date
Could the client do the translation to UTC/GMT, and that be what is
It seems that the areas DBMSs vary most are DDL (data definition
lanaguage) and DateTime signification.
Walker, Jed S wrote:
> We have just setup our first PostgreSQL system. We have a vendor product
> that connects via ODBC. That vendor product needs to talk in a different
> timezone than our database server is at. How can you specify a timezone
> to use through ODBC?
> Jed S. Walker
In response to
pgsql-odbc by date
|Next:||From: Greg Campbell||Date: 2005-06-09 16:14:30|
|Subject: Re: Set timezone in ODBC|
|Previous:||From: Del Stoliker||Date: 2005-06-09 15:32:34|
|Subject: Re: ODBC Error in logs|