In my previous article, I discussed about the easiest way to calculate the last date of any month in SQL SERVER 2012.
Today, we will discuss the easiest way to calculate the total number of days in a month in SQL SERVER 2012.
But before that, I would like to discuss how we were calculating the total number of days in a month in the previous versions of SQL SERVER (2005 & 2008)
In SQL Server 2005/2008
For Example :
DECLARE @DATE DATETIME SET @DATE='2012-12-10' SELECT DAY(DATEADD(ms,-2,DATEADD(MONTH, DATEDIFF(MONTH,0,@DATE)+1,0))) AS [Current Month] --RESULT Current Month ------------- 29 (1 row(s) affected)
In SQL Server 2012
For Example :
DECLARE @DATE DATETIME SET @DATE='2012-02-10' Select Day(EOMONTH(@DATE)) AS [Current Month] --RESULT Current Month ------------- 29 (1 row(s) affected)
[…] Find No. of Days in a Month in SQL […]