Re: Strange time zone +00:53:28

Поиск
Список
Период
Сортировка
От hubert depesz lubaczewski
Тема Re: Strange time zone +00:53:28
Дата
Msg-id 20130510103757.GA16357@depesz.com
обсуждение исходный текст
Ответ на Strange time zone +00:53:28  (Karsten Düsterloh <pg-bugs-ml@tal.de>)
Ответы Re: Strange time zone +00:53:28
Список pgsql-bugs
Дерево обсуждения 
On pią, maj 10, 2013 at 10:34:02 +0200, Karsten Düsterloh wrote:
> Under Pg 8.3, we used the timestamp
>   0001-01-01 00:00:00+01
> as an easy-to-remember marker for 'dunno, but predates any usual
> business dates' for fields of type timestamp with time zone.

Why didn't you use "-infinity" for this?

> Any ideas?
> Is this a known bug (I didn't find), maybe fixed in 9.2?

It's not a bug. Berlin timezone that far away has such not-round offset.

In time zone database you can find:

# Zone  NAME            GMTOFF  RULES   FORMAT  [UNTIL]
Zone    Europe/Berlin   0:53:28 -       LMT     1893 Apr
                        1:00    C-Eur   CE%sT   1945 May 24 2:00
                        1:00 SovietZone CE%sT   1946
                        1:00    Germany CE%sT   1980
                        1:00    EU      CE%sT

Best regards,

depesz

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

Предыдущее
От: Karsten Düsterloh
Дата:
Сообщение: Strange time zone +00:53:28
Следующее
От: Karsten Düsterloh
Дата:
Сообщение: Re: Strange time zone +00:53:28