Re: PL/SQL Function about dates
From: (wrong string) ópez <javi_at_eitb.com>
Date: 1997/12/02
Message-ID: <34849D04.7BF2_at_eitb.com>#1/1
Date: 1997/12/02
Message-ID: <34849D04.7BF2_at_eitb.com>#1/1
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 CET