SELECT MONTH(LEFT(DATENAME(MONTH,Getdate()),15) + ' 1 2016') Number ,(DATENAME(MONTH,Getdate())) MonthName
Find Month Name to Month number in SQL Server
This code snippet is for Find Month Name to Month number in SQL Server.
Loading
This code snippet is for Find Month Name to Month number in SQL Server.
SELECT MONTH(LEFT(DATENAME(MONTH,Getdate()),15) + ' 1 2016') Number ,(DATENAME(MONTH,Getdate())) MonthName