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.