Get Month Name

In Sql Server to find the month from a date you use the following command:

Month(DateTime)

This will give you the month number. To get the month name, you need to use the next command:

DateName(month, DateTime)

Happy Programming.