Re: date

From: DStevens <dstevens_at_navidec.com>
Date: Tue, 11 Dec 2001 14:08:31 -0700
Message-ID: <3C1675CF.B6439C4D@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:08:31 CST