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

From Mikko Tiihonen
Subject Re: BUG #2768: dates before year 1600 in timestamptz column
Date
Msg-id Pine.OSF.4.64.0611211802280.272415@kosh.hut.fi
Whole thread Raw
In response to Re: BUG #2768: dates before year 1600 in timestamptz column give strange results  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-bugs
On Tue, 21 Nov 2006, Heikki Linnakangas wrote:

> 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).


Ok. Thank you for clearing this up.

I'm sorry to have bothered you with the issue. I'll go back to wondering why
the java jdbc postgresql driver is 3x slower when it sees the odd timezone in
the response.

-Mikko

pgsql-bugs by date:

Previous
From: "Alex Deiter"
Date:
Subject: BUG #2778: make check failed
Next
From: "Mas Kus"
Date:
Subject: BUG #2775: Error select