SYSDATE and Daylight Saving Time

From: <plerohel_at_my-deja.com>
Date: 2000/08/01
Message-ID: <8m6li3$r00$1@nnrp1.deja.com>#1/1

Let's consider the 29th of October 2000 at 01:59:59.

select to_char(sysdate, 'DD-MM-YYYY HH24:MI:SS') from dual;

returns

TO_CHAR(SYSDATE,'DD

---

29-10-2000 01:59:59

One second later there is a time shift to comply with Daylight Saving Time and the same request returns

TO_CHAR(SYSDATE,'DD

---

29-10-2000 01:00:00

and about one hour later it returns

TO_CHAR(SYSDATE,'DD

---

29-10-2000 01:59:59

Question : how to make the difference from 01:59:59 before DST shift and 01:59:59 after DST shift in SQL ?

Philippe Le Rohellec

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Aug 01 2000 - 00:00:00 CDT