Solved

# WEEKS between DATES

Posted on 2000-04-06
Medium Priority
7,891 Views
Hi,

I am trying to find out the number of weeks between 2 dates.

The equivalent in SQL SERVER 7 would be
DateDiff(week,Date1,Date2)

Is there such a function in Oracle.

Thanks for helping..
0
Question by:ayoa

LVL 3

Expert Comment

ID: 2690846
No there isn't, but ironically there is a "MONTHS_BETWEEN".  Is that all you need or do you need a "week difference" function written for you in PL/SQL?

Gio
0

Author Comment

ID: 2692560
Week difference is really what I need..

Thanks
0

LVL 2

Expert Comment

ID: 2692748
-- gives you the day difference

select (trunc( date2, 'DDD')- trunc( date1, 'DDD')) diff, trunc( date2, 'DDD') date2, trunc( date1, 'DDD') date1
from (select sysdate date1, sysdate+4 date2 from dual)
;

-- gives you the week difference

select (trunc( date2, 'DAY')- trunc( date1, 'DAY'))/ 7 diff, trunc( date2, 'DAY') date2, trunc( date1, 'DAY') date1
from (select sysdate date1, sysdate+4 date2 from dual)
0

LVL 2

Expert Comment

ID: 2703432
Hi,

declare
dDate1 date := sysdate;
dDate2 date := sysdate + 21;
begin
dbms_output.put_line( 'The week difference is ' || trunc( ( dDate2 - dDate1 ) / 7 ) );
end;
/

Andrew.
0

Accepted Solution

Softchoice earned 20 total points
ID: 2705433
select trunc((to_date('01-JAN-2000')-to_date('22-DEC-1999'))/7) weeks from dual
0

## Featured Post

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
###### Suggested Courses
Course of the Month14 days, 14 hours left to enroll