Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: date
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