I am afraid this may not give the result I am looking for. The sp x(text) gives me the result always will be UTC time zone. My requirement here is, that i should pass the UTC time in text as a parameter and should return local timestamp with timzone for that UTC time.
select x('2010-03-28 01:00:03 243') should return '2010-03-28 02:00:03.243 + 01' as locks are supposed to jump from 1AM directly to 2AM when my clock is set to GMT select x ('2010-03-28 02:00:03 243') should return '2010-03-28 03:00:03.243 + 01' select x ('2010-03-28 03:00:03 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 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