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

Leave a Comment

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