world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
CREATE FUNCTION dbo.f__GetDaysInMonth( @Date DATE ) RETURNS TINYINT AS BEGIN DECLARE @Days TINYINT; SELECT @Days = DAY(DATEADD(month, DATEDIFF(MONTH, 0, @Date) + 1, -1)); RETURN @Days END; GO --Usage SELECT dbo.f__GetDaysInMonth('11-Apr-2015')
No comments:
Post a Comment