7.2 Beta timezone woes

From: Elein <elein(at)nextbus(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: elein <elein(at)nextbus(dot)com>
Subject: 7.2 Beta timezone woes
Date: 2002-01-12 01:50:34
Message-ID: 3C3F966A.5050705@nextbus.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


When I store a timestamptz with a non-client timezone,
it is stored in my table converted GMT.
Then, every access to it is in my client timezone, including
extract( timezone from value).

I want to be able to access the timestamps with the
timezone information I input it with.

The way it is puts the burden entirely on the client to figure out
what timezone the data is for and force the appropriate
timezone( 'MST', value) formatting to it for arithmetic and display.
(timzone() requires that we know whether it was day light savings
or not.) Or before and after the query set time zone which
eliminates having to know about day light savings. But
I don't want the whole session to be in the timezone of
the one row of data. I want the timestamp to know its
timezone.

Am I missing something or trying to make it do something
too clever?

thanks for your help,

elein(at)nextbus(dot)com

--
--------------------------------------------------------
elein(at)nextbus(dot)com
(510)420-3120
www.nextbus.com
spinning to infinity, hallelujah
--------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-01-12 03:38:54 Re: 7.2 Beta timezone woes
Previous Message Cindy 2002-01-12 00:30:26 Re: retrieving a function?