Re: Timezone database changes

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: Timezone database changes
Дата
Msg-id 470CE6E2.EE98.0025.0@wicourts.gov
обсуждение исходный текст
Ответ на Re: Timezone database changes  (Magne Mæhre <Magne.Mahre@Sun.COM>)
Ответы Re: Timezone database changes  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Timezone database changes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
>>> On Wed, Oct 10, 2007 at 12:23 PM, in message
<470D0A90.9000401@sun.com>, Magne
Mæhre <Magne.Mahre@Sun.COM> wrote: 
> An interesting observation is that,
> as far as I can tell, the original time zone is only applied when
casting
> the element to a string.  Apart from that, it's not used.
It's been a while since I looked at it, but my recollection is that
much of the standard date/time math which people assert can't handle
practical use cases do work if the timestamps and times WITH TIME
ZONE have a time zone in the offset-from-UTC format.  I have yet to
see anyone provide an example where this isn't true; if anyone has
such an example, it would be instructive to see it.
-Kevin



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Skytools committed without hackers discussion/review
Следующее
От: "Marko Kreen"
Дата:
Сообщение: Re: Skytools committed without hackers discussion/review