Get week number from dates in T-SQL

date, t-sql

Solution

Have a look at DATEPART

SELECT DATEPART(wk, GETDATE())

Problem

How do I get the week number from dates in T-SQL?

Original source