Re: BUG #2768: dates before year 1600 in timestamptz column give strange results

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Mikko Tiihonen" <mikko(dot)tiihonen(at)iki(dot)fi>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #2768: dates before year 1600 in timestamptz column give strange results
Date: 2006-11-21 11:23:42
Message-ID: 4562E1BE.2000105@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Amelio 2006-11-21 12:37:39 BUG #2773: Problem pg_get_serial_sequence
Previous Message Heikki Linnakangas 2006-11-21 11:00:49 Re: BUG #2768: dates before year 1600 in timestamptz column give strange results