Re: [HACKERS] Time bug with small years

2011-11-24 Thread Tom Lane
Robert Haas writes: > On Wed, Nov 23, 2011 at 11:45 PM, Rod Taylor wrote: >> sk_test=# select '1894-01-01'::timestamp with time zone; >> timestamptz >> -- >> 1894-01-01 00:00:00-05:17:32 >> (1 row) > On my system, all current time zone offsets are multiples

Re: [HACKERS] Time bug with small years

2011-11-24 Thread Robert Haas
On Wed, Nov 23, 2011 at 11:45 PM, Rod Taylor wrote: > sk_test=# select '1894-01-01'::timestamp with time zone; > timestamptz > -- >  1894-01-01 00:00:00-05:17:32 > (1 row) I believe that -05:17:32 is the offset of your local time zone as compared with UTC. Fo

Re: [HACKERS] Time bug with small years

2011-11-24 Thread Richard Huxton
On 24/11/11 04:45, Rod Taylor wrote: I have no idea what is going on with the minutes/seconds, particularly for years under 1895 where it gets appended onto the timezone component? sk_test=# select version(); version -

[HACKERS] Time bug with small years

2011-11-24 Thread Rod Taylor
I have no idea what is going on with the minutes/seconds, particularly for years under 1895 where it gets appended onto the timezone component? sk_test=# select version(); version Po