Re: Set timezone in ODBC

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.

-----Original Message-----
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
Cc: pgsql-odbc(at)postgresql(dot)org
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
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
>