Skip site navigation (1) Skip section navigation (2)

Re: Set timezone in ODBC

From: "Walker, Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
To: "Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Set timezone in ODBC
Date: 2005-06-09 16:30:37
Message-ID: 4A59B6AA01F1874283EA66C976ED51FC0E1AE3@COENGEXCMB01.cable.comcast.com (view raw or flat)
Thread:
Lists: pgsql-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
> 

Responses

pgsql-odbc by date

Next:From: Joel FradkinDate: 2005-06-09 17:51:07
Subject: Re: trouble removing 8.0 driver in xp
Previous:From: Alberto VeloDate: 2005-06-09 16:22:32
Subject: Re: ODBC Error in logs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group