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

Home -> Community -> Usenet -> c.d.o.server -> Re: date

Re: date

From: Thierry <thierry.constant2_at_wanadoo.fr>
Date: Tue, 11 Dec 2001 22:30:20 +0100
Message-ID: <3c167a58$0$198$626a54ce@news.free.fr>


Thanks ...

"DStevens" <dstevens_at_navidec.com> a écrit dans le message de news: 3C1675CF.B6439C4D_at_navidec.com...
> Date - (1/24)
>
> SQL> select sysdate, sysdate - (1/24) from dual;
>
> SYSDATE SYSDATE-(1/24)
> ------------------- -------------------
> 12/11/2001 14:07:55 12/11/2001 13:07:55
>
> Elapsed: 00:00:00.00
>
>
> Thierry wrote:
>
> > Hi,
> >
> > how can I substract an hour from a date ??
> >
> > Thanks for your answer ....
>
Received on Tue Dec 11 2001 - 15:30:20 CST

Original text of this message

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