T-SQL – How to output name of month

The following T-SQL statement shows how output the name of the month from a date.

For example, 16 March 2019 would output March.

SELECT DateName( month , GETDATE() ) as Month_Name

Was this article helpful?

Related Articles