Re: PL/SQL Question

Hi,

[Quoted] if you subtract one date from another, you'll receive number of days between two dates. Multiply it by 86400 to get number of seconds. There's no way i know to get more accurate number.

Regards,
Igor

dicaprio 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 ;
>
> and the OUT is a wrong result.
> Thanks in advance
>
> Veramente Grato
> Clemente di Caprio
>
> dicaprio_at_tin.it
 

-- 
Igor Sereda,
ITC, Russia