Get Month Name From Month Number in SQLPosted November 24, 2013 by Bhargav PatelIn SQL ServerLeave a Comment on Get Month Name From Month Number in SQL Month Name in SQL Declare @Month bigint Select @Month = 2 SELECT DATENAME(month, DATEADD(month, @Month, -1 )) Output :- February