Number of weeks between two dates in sql

Number of weeks between two dates in sql

 

 

You get number of week between two date using datediff function

 

SELECT DATEDIFF( week,date_1,date_2)

FROM title