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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs