PL/SQL Question

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 ;  

and the OUT is a wrong result.
Thanks in advance                                            

Veramente Grato

                                     Clemente di Caprio

dicaprio_at_tin.it Received on Tue Apr 14 1998 - 09:31:41 CDT