Re: Odd behaviour of timestamptz

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: Odd behaviour of timestamptz
Дата
Msg-id 20070221124807.GB30975@svana.org
обсуждение исходный текст
Ответ на Re: Odd behaviour of timestamptz  (Matteo Beccati <php@beccati.com>)
Список pgsql-general
On Wed, Feb 21, 2007 at 09:40:05AM +0100, Matteo Beccati wrote:
> > test=# SELECT * from test;
> >            data
> > ---------------------------
> >  1910-01-10 00:00:00+01:24
> >  1990-01-10 00:00:00+01
> > (2 rows)
>
> Actually this one was built from source (CVS HEAD from yesterday), so
> it's not a packaging issue as I first was thinking.

Hmm, 1910 is before the time that timezones where spaced in nice
intervals of an hour, and there where plenty of places in the world
that had very odd offsets relative to what is used today.

Between 1909 and 1937 Amsterdam was 19 minutes 32.13 seconds ahead of
GMT, so I imagine entiring a time in that period will produce similar
results.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Вложения

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

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: REVOKE ALL
Следующее
От: "David Legault"
Дата:
Сообщение: Re: REVOKE ALL