Re: PL/SQL Function about dates
From: Peter Rak <prak_at_vsz.sk>
Date: 1997/12/03
Message-ID: <34855AAE.3FD1445B_at_vsz.sk>#1/1
Date: 1997/12/03
Message-ID: <34855AAE.3FD1445B_at_vsz.sk>#1/1
Hi,
SQL> select sysdate,trunc(sysdate),sysdate-trunc(sysdate) days from dual;
SYSDATE TRUNC(SYSDATE) DAYS
----------------- ----------------- -----03.12.97 14:09:36 03.12.97 00:00:00 0.590
Peter.
Acácio Nuno wrote:
> Hi PL/SQL programers,
>
> I need to kown the number of days between two dates, if you have a
> function that accepts these
> 2 dates as parameters and returns the number of days between them,
> pleaaaaaase send me!
>
> THANKS!!!!! :)
Received on Wed Dec 03 1997 - 00:00:00 CET