Re: PL/SQL Question

From: Steve Cosner <stevec_at_zimmer.csufresno.edu>
Date: 14 Apr 1998 15:22:48 GMT
Message-ID: <6gvv08$jqq3@hendrix.csufresno.edu>

In article <01bd67b2$43e71820$0f2284c0_at_PC_TELECOM.UNINA.IT>, dicaprio <dicaprio_at_tin.it> wrote:
>Hi,
>
>I have got this problem : I must subtract a date_variable from another ;
>e.g. I want to subtract one hour 1:00 from SYSDATE
>
> Select (SYSDATE-TO_DATE('1:00','hh24:mi') from dual ;

Try:

Select SYSDATE - 1/24 from dual;
or:

Select to_char(SYSDATE - 1/24,'hh24:mi') from dual;

Steve Cosner Received on Tue Apr 14 1998 - 10:22:48 CDT