## Function to get last day for a monthFebruary 22, 2005
Author: catur bharata CREATE FUNCTION last_day (@date DATETIME) RETURNS INT AS BEGIN DECLARE @n_month INT, @n_date DATETIME, @n_year INT, @l_day INT DECLARE @i INT SET @n_month= MONTH(@date) SET @n_year = YEAR(@date) SET @i = 1 IF @n_year % 4 = 0 SET @l_day = (CASE @n_month WHEN 1 THEN 31 WHEN 2 THEN 29 WHEN 3 THEN 31 WHEN 4 THEN 30 WHEN 5 THEN 31 WHEN 6 THEN 30 WHEN 7 THEN 31 WHEN 8 THEN 31 WHEN 9 THEN 30 WHEN 10 THEN 31 WHEN 11 THEN 30 ELSE 31 END) IF @n_year % 4 > 0 SET @l_day = (CASE @n_month WHEN 1 THEN 31 WHEN 2 THEN 28 WHEN 3 THEN 31 WHEN 4 THEN 30 WHEN 5 THEN 31 WHEN 6 THEN 30 WHEN 7 THEN 31 WHEN 8 THEN 31 WHEN 9 THEN 30 WHEN 10 THEN 31 WHEN 11 THEN 30 ELSE 31 END) RETURN(@l_day) END
Back to |