Hello everyone, I am going to share the code sample for how to get the month form date-time using the SQL Server 2008 and higher versions of SQL Server.
query for get month from sql date-time
query for get month from sql date-time
SELECT DATENAME(MONTH, GETDATE()) AS [MONTH]