Re: Set timezone in 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