Date Different in SQL Server DB Vs Oracle DB

How can I find differences in weeks between 2 dates by using SQL statement. I answered this question by using SQL server syntax and compare this with Oracle syntax. Read More!