Re: Odd behaviour of timestamptz - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: Odd behaviour of timestamptz
Date
Msg-id 20070221124807.GB30975@svana.org
Whole thread Raw
In response to Re: Odd behaviour of timestamptz  (Matteo Beccati <php@beccati.com>)
List pgsql-general
On Wed, Feb 21, 2007 at 09:40:05AM +0100, Matteo Beccati wrote:
> > test=# SELECT * from test;
> >            data
> > ---------------------------
> >  1910-01-10 00:00:00+01:24
> >  1990-01-10 00:00:00+01
> > (2 rows)
>
> Actually this one was built from source (CVS HEAD from yesterday), so
> it's not a packaging issue as I first was thinking.

Hmm, 1910 is before the time that timezones where spaced in nice
intervals of an hour, and there where plenty of places in the world
that had very odd offsets relative to what is used today.

Between 1909 and 1937 Amsterdam was 19 minutes 32.13 seconds ahead of
GMT, so I imagine entiring a time in that period will produce similar
results.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: REVOKE ALL
Next
From: "David Legault"
Date:
Subject: Re: REVOKE ALL