Re: SYSDATE and Daylight Saving Time

Yes I did, but to use this function you must give parameters saying saying if the date you are trying to convert is DST (summer time) or not. And if you don't know...

Philippe

In article <965291454.13964.0.nnrp-01.c2de9e86_at_news.demon.co.uk>,   "SJ Emmons" <SEmmons_at_remove_nospam.maracis.co.uk> wrote:
> 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.
>
>

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