Time bug with small years
От | Rod Taylor |
---|---|
Тема | Time bug with small years |
Дата | |
Msg-id | CAKddOFAEzv2J1PmVjgEJS5hoJ=zwoqtj26AjfwOL0oUJn3Vfag@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Time bug with small years
Re: Time bug with small years |
Список | pgsql-hackers |
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/>
В списке pgsql-hackers по дате отправления: