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

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 13 Jan 2000 18:45:23 +0800
Message-ID: <387DACC3.53A7@yahoo.com>

Eric D
>
> 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

number_of_days := abs ( my_date - sysdate ); --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 13 2000 - 04:45:23 CST