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