Getting Month Name Information Using DATENAME Function in SQL Server

Hello everyone,

In this article, I will try to give information about how to get Month Information using DATENAME Function in SQL Server.

In SQL Server, in some cases, you may want to get the month information from the date information by using the DATENAME function.

You can easily do this using the code below.

DECLARE @date datetime = '2018-07-01';
SELECT DATENAME(month, @date) AS Result;

When you run the code, you will get a result similar to the one below.

As you can see, we have brought the name of the month using the DATENAME function.

Good luck to everyone in business and life.