Gouse <gkhaji@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
