Gouse <gkh...@gmail.com> writes: > I find that the to_timestamp giving the incorrect result for the DST time > period.
On what grounds do you claim it's incorrect? > select to_timestamp('2010-03-28 01:00:03 243','YYYY-MM-DD HH24:MI:SS.MS') > results '2010-03-28 02:00:03.243 + 01' , I am not sure if this is correct. The reason it does that is that actually there *is* no such local time as 1:00:03 on that date. Clocks are supposed to jump from 1AM directly to 2AM. PG's actual behavior is that the bogus time is interpreted as standard time (UTC+0 in your case). The only other thing it could plausibly do is throw an error, and that has been judged to be less useful. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs