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: "Jeff Eckermann" <jeff_eckermann(at)yahoo(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Set timezone in ODBC
Date: 2005-06-10 14:14:53
Message-ID: 4A59B6AA01F1874283EA66C976ED51FC0E1AF3@COENGEXCMB01.cable.comcast.com (view raw or flat)
Thread:
Lists: pgsql-odbc
Unfortunately I'm not doing the ODBC piece, but I had suggested that.
Maybe they just don't know how to issue "set timezone" through an ODBC
interface? Any thoughts on that? 

-----Original Message-----
From: Jeff Eckermann [mailto:jeff_eckermann(at)yahoo(dot)com] 
Sent: Friday, June 10, 2005 7:56 AM
To: Walker, Jed S
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Set timezone in ODBC

--- Greg Campbell <greg(dot)campbell(at)us(dot)michelin(dot)com>
wrote:

> 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?

Maybe this is just too blindingly obvious, but I haven't seen it
mentioned in this thread: why not just issue a "set timezone" command
from your client session?  Has that been tried, and with failure?

> 
> 
> 
> 
> 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 begin:vcard
> fn:Greg Campbell
> n:Campbell;Greg
> org:Michelin North America - US5 Lexington;ENG-ASE 
> email;internet:greg(dot)campbell(at)us(dot)michelin(dot)com
> title:ASE Systems Engineer
> tel;work:803-951-5561/x75561
> x-mozilla-html:FALSE
> version:2.1
> end:vcard
> 
> > 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
> 



		
__________________________________
Yahoo! Mail Mobile
Take Yahoo! Mail with you! Check email on your mobile phone. 
http://mobile.yahoo.com/learn/mail 

Responses

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2005-06-10 18:38:00
Subject: Re: Set timezone in ODBC
Previous:From: Jeff EckermannDate: 2005-06-10 13:56:10
Subject: Re: Set timezone in ODBC

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