Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Weeks Between
- Thread starter nickty
- Start date
SantaMufasa
Technical User
Nickty,
How does this look:
col x heading "Date Differences"
select end_date||' and '||start_date||' differ by '||
trunc((end_date-start_date)/7)||' weeks and '||
mod(end_date-start_date,7)||' days.' x
from two_dates
Date Differences
------------------------------------------------------
30-JUL-03 and 01-AUG-02 differ by 51 weeks and 6 days.
31-JUL-03 and 01-AUG-02 differ by 52 weeks and 0 days.
How does this look:
col x heading "Date Differences"
select end_date||' and '||start_date||' differ by '||
trunc((end_date-start_date)/7)||' weeks and '||
mod(end_date-start_date,7)||' days.' x
from two_dates
Date Differences
------------------------------------------------------
30-JUL-03 and 01-AUG-02 differ by 51 weeks and 6 days.
31-JUL-03 and 01-AUG-02 differ by 52 weeks and 0 days.
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question