Saturday, January 8, 2011

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

No comments:

Post a Comment