Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Function about dates
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!!!!! :)
Select to_date('19971203','yyyymmdd') - to_date('19971202','yyyymmdd')
from dual;
Result = 1
Regards from Basque Country Received on Tue Dec 02 1997 - 00:00:00 CST