I have no idea what is going on with the minutes/seconds, particularly for years under 1895 where it gets appended onto
thetimezone component?<br /><br /><br />sk_test=# select version();<br
/> version <br />
----------------------------------------------------------------------------------------------------------------<br
/> PostgreSQL9.1.1 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit<br />
(1row)<br />-- uname -a output: Linux rbt-dell 3.0.0-13-generic #22-Ubuntu SMP Wed Nov 2 13:27:26 UTC 2011 x86_64
x86_64x86_64 GNU/Linux<br /><br /><br />sk_test=# select '1894-01-01'::timestamp with time zone;<br />
timestamptz <br /> ------------------------------<br /> 1894-01-01 00:00:00-05:17:32<br />(1 row)<br /><br
/>sk_test=#select '1895-01-01'::timestamp with time zone;<br /> timestamptz <br
/>------------------------<br/> 1895-01-01 00:17:32-05<br /> (1 row)<br /><br />sk_test=# select
'1896-01-01'::timestampwith time zone;<br /> timestamptz <br />------------------------<br /> 1896-01-01
00:00:00-05<br/>(1 row)<br /><br />sk_test=# show timezone;<br /> TimeZone <br /> -----------<br /> localtime<br />(1
row)<br/><br />sk_test=# set timezone= 'est5edt';<br />SET<br />sk_test=# select '1895-01-01'::timestamp with time
zone;<br/> timestamptz <br />------------------------<br /> 1895-01-01 00:00:00-05<br />(1 row)<br /><br
/>sk_test=#select '1894-01-01'::timestamp with time zone;<br /> timestamptz <br
/>------------------------<br/> 1894-01-01 00:00:00-05<br />(1 row)<br /><br /><br /><br />I can duplicate with the
exactsame version of Pg on Intel hardware with kernel:<br /><br />Linux infongd2888
2.6.28.8-20101130b-iscsi-ntacker-fasync-mremap-amd-sec6-grsec#1 SMP Tue Nov 30 18:27:29 CET 2010 i686 GNU/Linux<br
/><br/>