Re: [PL/SQL} NUMBER of DAY function exist ?

The date is measured in days
you should be able to have
day_num := trunc(sysdate) - trunc(my_date);

without problem.

Hth,

--
Sybrand Bakker, Oracle DBA
Eric D Eric_at_netcom.ca> <D<SPAM> wrote in message news:z9nf4.203716$5r2.552862_at_tor-nn1.netcom.ca...
> Hi everyone
>
> Thank a lot for that.
>
> I have a other question.
>
> I would like to built a function that give me the number of day between
your
> date and today.
> It could be a negative day also. But it's not possible to have the real
> number of day on this topic.
>
> DAY_NUM := (SYSDATE - MY_DATE) / (60 * 60 *24)
>
> How do you do ?
>
> Pierre
>
>
>
Received on Thu Jan 13 2000 - 12:40:19 CST