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.campbell@us.michelin.com]
Sent: Thursday, June 09, 2005 10:15 AM
To: Walker, Jed S
Cc: pgsql-odbc@postgresql.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

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.campbell@us.michelin.com]
> Sent: Thursday, June 09, 2005 10:15 AM
> To: Walker, Jed S
> Cc: pgsql-odbc@postgresql.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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--- Greg Campbell <greg.campbell@us.michelin.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.campbell@us.michelin.com]
> > Sent: Thursday, June 09, 2005 10:15 AM
> > To: Walker, Jed S
> > Cc: pgsql-odbc@postgresql.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.campbell@us.michelin.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@postgresql.org)
>




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

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org