monthname function in sql server code example

Example: monthname sql

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