Get week number from dates in T-SQL December 19, 2023 by Tarik Have a look at DATEPART SELECT DATEPART(wk, GETDATE())