[BUGS] to_timestamp returns the incorrect result for the DST fall over time.

010-03-28 02:00:03 243','-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://postgre

[BUGS] Re: to_timestamp returns the incorrect result for the DST fall over time.

he output to be '2010-03-28 02:00:03.243 + 01' , instead I am getting the result '2010-03-28 03:00:03.243 + 01'. The store procedure works well for the UTC time starting from '2010-03-28 02:00:00 000'. The problem only lies for the UTC time period from

[BUGS] Re: to_timestamp returns the incorrect result for the DST fall over time.

243') should return '2010-03-28 04:00:03.243 + 01' Thanx, Gouse -- View this message in context: http://postgresql.1045698.n5.nabble.com/to-timestamp-returns-the-incorrect-result-for-the-DST-fall-over-time-tp3327393p3330384.html Sent from the PostgreSQL - bugs mailing list

[BUGS] Re: to_timestamp returns the incorrect result for the DST fall over time.

Now this works great. Thanks for the help. 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-tp3327393p3331798.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com