Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL Function about dates

Re: PL/SQL Function about dates

From: Javi López <javi_at_eitb.com>
Date: 1997/12/02
Message-ID: <34849D04.7BF2@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 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US