Get month name from week number in SQL Server


To Get Month name from Week Number we have to execute following query



declare @Year char(4), @Week INT, @month int
select @Year = '2020', @Week = 30
SET @month = month(dateadd(wk,@Week,@Year + '/01/01'))
SELECT DATENAME(month, DATEADD(month, @month, -1 ))as Nameofmonth




Here Week =30 and Year is 2020  

Result:-
Nameofmonth
July

No comments:

Post a Comment