Get week number from dates in T-SQL

How do I ge开发者_运维问答t the week number from dates in T-SQL?

Have a look at DATEPART

SELECT DATEPART(wk, GETDATE())

It is best to use the following:

select DATEPART(ISO_WEEK, getDate())

As when you have a year with a week 53 as in the case of 2015 it give unreliable results. (Certainly on 2008 R2)

select DATEPART(WK, '01/03/2016')

Gives variable results around week 53. When run the week after 3rd Jan it produced the value 1. When run now for the same date it gives the value 2.

Or use DATEDIFF like this: DATEDIFF(wk,GETDATE(),GETDATE()+7) to find the number of weeks between two days