how to get month name from month number in sql server code example

Example 1: sql get month name

SELECT GETDATE() 'Today', FORMAT(GETDATE(),'MMMM') 'Month Name'

Example 2: monthname sql

SELECT DATENAME(mm,GETDATE())[Month Name]