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

Re: Set timezone in ODBC

From: "Greg Campbell" <greg(dot)campbell(at)us(dot)michelin(dot)com>
To: "Walker Jed S" <Jed_Walker(at)cable(dot)comcast(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Set timezone in ODBC
Date: 2005-06-09 21:31:50
Message-ID: 42A8B546.5020408@us.michelin.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Curious,
I did a brief experiment on the PostgreSQL server with psql without ODBC 
inverviening
.
Something like
SET TIME ZONE INTERVAL '08:00' HOUR TO MINUTE;
SELECT CURRENT_TIMESTAMP AS TEST_TIME;
SET TIME ZONE DEFAULT;
SELECT CURRENT_TIMESTAMP AS TEST_TIME;

It did return timestamps that were marked as 8 hrs. different.

I am wondering if ODBC is just not passing the adjusted time. I don't 
know why it would be biased in one direction (message to server being 
adjusted, but data coming back not ???)
Is your field of 'timestamp with timezone' or just timestamp?




Walker, Jed S wrote:

> 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
>>
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
>                http://archives.postgresql.org

Attachment: greg.campbell.vcf
Description: text/x-vcard (241 bytes)

In response to

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2005-06-10 13:56:10
Subject: Re: Set timezone in ODBC
Previous:From: Joel FradkinDate: 2005-06-09 17:51:07
Subject: Re: trouble removing 8.0 driver in xp

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