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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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