Function that returns number of days in a year

[bestdev]

Function that returns number of days in a year

CREATE FUNCTION dbo.GetDaysInYear(@Date datetime)

RETURNS int
AS
BEGIN

RETURN CASE WHEN (YEAR(@Date) % 4 = 0 AND
YEAR(@Date) % 100 != 0) OR
(YEAR(@Date) % 400 = 0)
THEN 366
ELSE 365
END
END

GO