We don't want to change the timezone on the server.
We could have the client send the timestamp with timezone but without
setting the time (using set timezone to) then they get back the
timestamps in the server timezone which they don't want.
From: Greg Campbell [mailto:greg(dot)campbell(at)us(dot)michelin(dot)com]
Sent: Thursday, June 09, 2005 10:15 AM
To: Walker, Jed S
Subject: Re: [ODBC] Set timezone in ODBC
To configure a server for a default timezone, see the PostgreSQL admin
guide for the PostgreSql configuration file, the TIMEZONE parameter.
Walker, Jed S wrote:
> We have just setup our first PostgreSQL system. We have a vendor
> that connects via ODBC. That vendor product needs to talk in a
> timezone than our database server is at. How can you specify a
> to use through ODBC?
> Jed S. Walker
pgsql-odbc by date
|Next:||From: Joel Fradkin||Date: 2005-06-09 17:51:07|
|Subject: Re: trouble removing 8.0 driver in xp|
|Previous:||From: Alberto Velo||Date: 2005-06-09 16:22:32|
|Subject: Re: ODBC Error in logs|