7.2 Beta timezone woes
От | Elein |
---|---|
Тема | 7.2 Beta timezone woes |
Дата | |
Msg-id | 3C3F966A.5050705@nextbus.com обсуждение исходный текст |
Ответы |
Re: 7.2 Beta timezone woes
|
Список | 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@nextbus.com -- -------------------------------------------------------- elein@nextbus.com (510)420-3120 www.nextbus.com spinning to infinity, hallelujah --------------------------------------------------------
В списке pgsql-general по дате отправления: