Re: PL/SQL Question

From: Igor Sereda <sereda_at_spb.runnet.ru>
Date: Wed, 15 Apr 1998 17:33:32 -0400
Message-ID: <353527AC.BA7083F9@spb.runnet.ru>

Hi,

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 Received on Wed Apr 15 1998 - 16:33:32 CDT