Re: PL/SQL Function about dates

From: Peter Rak <prak_at_vsz.sk>
Date: 1997/12/03
Message-ID: <34855AAE.3FD1445B@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 CST