Postgres Pro
Downloads
Home   >   mailing lists

Re: Strange time zone +00:53:28 - Mailing list pgsql-bugs

From hubert depesz lubaczewski
Subject Re: Strange time zone +00:53:28
Date
Msg-id 20130510103757.GA16357@depesz.com
Whole thread Raw
In response to Strange time zone +00:53:28  (Karsten Düsterloh <pg-bugs-ml@tal.de>)
Responses Re: Strange time zone +00:53:28  (Karsten Düsterloh <pg-bugs-ml@tal.de>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: Karsten Düsterloh
Date:
Subject: Strange time zone +00:53:28
Next
From: Karsten Düsterloh
Date:
Subject: Re: Strange time zone +00:53:28