Search This Blog

Tuesday 3 February 2015

Get Month Name in SQL Server based on Month number?

Step 1 - Get Month Name

DECLARE @MonthNumber int

--PASS MONTH NUMBER HERE
SET @MonthNumber = 1

DECLARE @MonthName varchar(15)

SET @MonthName = DateName( Month , DateAdd( Month , @MonthNumber , 0 ) - 1 )


PRINT @MonthName


No comments:

Post a Comment