Re: date range question

I figured it out, using to_date(x) - to_date(sysdate)

thanks.

phil2phil wrote:
> hi,
> Is there anyway to know how many days have passed between two dates? I
> have a table with a date (day application was submitted) I need to
> compare that with today's date and see if a week (7 days) have gone by
> since then.
>
> Thanks.
Received on Mon Nov 21 2005 - 09:53:53 CST