to_timestamp returns the incorrect result for the DST fall over time. - Mailing list pgsql-bugs

Hi

I find that the to_timestamp giving the incorrect result for the DST time
period.


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.

select to_timestamp('2010-03-28 02:00:03 243','YYYY-MM-DD HH24:MI:SS.MS')
results '2010-03-28 02:00:03.243 + 01'

Note- The clokc on the system was GMT London.  The date 2010-03-28 is the
day of the DST.
Postgres DB versoin is 8.0

Thanks,
Gouse


--
View this message in context:
http://postgresql.1045698.n5.nabble.com/to-timestamp-returns-the-incorrect-result-for-the-DST-fall-over-time-tp3327393p3327393.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.