From: | Gouse <gkhaji(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: to_timestamp returns the incorrect result for the DST fall over time. |
Date: | 2011-01-06 13:17:17 |
Message-ID: | 1294319837133-3330384.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | areveille | 2011-01-06 14:08:11 | Re: BUG #5641: Can not create any python language |
Previous Message | Dave Page | 2011-01-06 09:30:07 | Re: BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted" |