Get Month Name

calendar.jpg

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.

No Responses

Leave a Reply

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