Re: PL/SQL Function about dates

Hi

You might get answers you don't expect.
If you want to deal with whole days then use TRUNC(date) - TRUNC(date)

John

>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 CET