Re: PL/SQL Function about dates

Hi:

   The function, in my opinion is unnecessary, because you can substract directly two dates obtaining the days elapsed. But here is one:

create or replace FUNCTION dimedias(a date, b date) RETURN number IS
BEGIN              RETURN b-a;
END;         Sorry for my english and good bye.

Acácio Nuno <a.nuno_at_ifb.pt> escribió en artículo <3483EFF8.549E6F0C_at_ifb.pt>...
> 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 Tue Dec 02 1997 - 00:00:00 CST