Get Number Of Days Of Given Month

In this blog, we create a function that returns the number of days for the given month.

In this blog, we are creating a function that will return the number of days for a given month. Below is the code snippet for the function that is used to retrieve the number of days. 

CREATE FUNCTION Func_GetDate(@Date_ [date])
RETURNS [int]
BEGIN
DECLARE @Date [datetime];
SET @Date=@Date_;
DECLARE @Day int;
SET @Day=Day(@Date);
DECLARE @new_Date [datetime];
SET @new_Date=dateadd(day,-@day+1,@Date);
SET @Date=dateadd(day,-1,dateadd(month,1,@new_Date));
return datediff(Day,@new_Date,@Date)+1;
END

Example