| From: | Mikko Tiihonen <mikko(dot)tiihonen(at)iki(dot)fi> |
|---|---|
| To: | Heikki Linnakangas <heikki(at)enterprisedb(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #2768: dates before year 1600 in timestamptz column |
| Date: | 2006-11-21 16:06:33 |
| Message-ID: | Pine.OSF.4.64.0611211802280.272415@kosh.hut.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | rahman sule | 2006-11-21 16:28:18 | PGSQL SETUP PROBLEM |
| Previous Message | Tom Lane | 2006-11-21 15:53:51 | Re: Postgresql out-of-memory error |