Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: SYSDATE and Daylight Saving Time

Re: SYSDATE and Daylight Saving Time

From: SJ Emmons <SEmmons_at_remove_nospam.maracis.co.uk>
Date: 2000/08/02
Message-ID: <965291454.13964.0.nnrp-01.c2de9e86@news.demon.co.uk>#1/1

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...

> 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 Wed Aug 02 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US