DateName function - SQL

SELECT DATENAME(month, GETDATE()) AS 'MonthName';