Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #2768: dates before year 1600 in timestamptz column give strange results - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: BUG #2768: dates before year 1600 in timestamptz column give strange results
Date
Msg-id 4562E1BE.2000105@enterprisedb.com
Whole thread Raw
In response to BUG #2768: dates before year 1600 in timestamptz column give strange results  ("Mikko Tiihonen" <mikko.tiihonen@iki.fi>)
Responses Re: BUG #2768: dates before year 1600 in timestamptz column
List pgsql-bugs
Tree view 
Heikki Linnakangas wrote:
> Tom Lane wrote:
>>  The weird offset from GMT is probably a function of your local
>> timezone, which you didn't
>> mention.
>
> Most likely "Europe/Helsinki". I can reproduce the problem with that:

Confirmed that it's expected behavior. The timezone really was
GMT+01:39:52 until  May 1st, 1921. See

http://igs.kirjastot.fi/iGS/kysymykset/haku.aspx?word=Kes%C3%A4aika

and search for "1921" for details (in Finnish).

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: "Jaime Casanova"
Date:
Subject: Re: BUG #2764: Capital letter in tables or columns not supported
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #2768: dates before year 1600 in timestamptz column give strange results