Skip site navigation (1) Skip section navigation (2)

to_timestamp returns the incorrect result for the DST fall over time.

From: Gouse <gkhaji(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: to_timestamp returns the incorrect result for the DST fall over time.
Date: 2011-01-04 17:17:05
Message-ID: 1294161425291-3327393.post@n5.nabble.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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.

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2011-01-04 18:26:50
Subject: Re: to_timestamp returns the incorrect result for the DST fall over time.
Previous:From: Joshua TolleyDate: 2011-01-04 16:34:57
Subject: Re: BUG #5809: bigserial duplicate value

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group