Convert Month Number to Month Name in SQL Server

One of my colleague asked me a simplest way to convert Month Number to Month Name. Here’s the simplest way in my opinion :

DECLARE @MonthNo smallint
SET @MonthNo = 11
SELECT DateName(mm,DATEADD(mm,@MonthNo ,-1)) as [MonthName]

There are alternate ways also to achieve this.Share your ideas.

Reference: Narendra Singh (

Leave a Reply

Your email address will not be published. Required fields are marked *