Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: SYSDATE and Daylight Saving Time
Have you looked at the NEW_TIME function?
HTH
-- S Emmons mailto:SEmmons_at_maracis.co.uk <plerohel_at_my-deja.com> wrote in message news:8m6li3$r00$1_at_nnrp1.deja.com...Received on Wed Aug 02 2000 - 00:00:00 CDT
> 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.