Listing 8: Creating the fn_EndOfThisMonth Function

CREATE FUNCTION dbo.fn_EndOfThisMonth() RETURNS DATETIME
AS
BEGIN
  RETURN DATEADD(month, 1, CONVERT(CHAR(6), GETDATE(), 112) + '01') - 1;
END
GO





1