Re: date range question

phil2phil wrote:
> 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.

1. Don't top post.
2. TO_DATE(SYSDATE)? Surely you jest! -- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)