sql server2008 R2日期函数返回当月最后一天

最近接手了个sql server的数据库，开始在DG写代码优化的时候发现连接的数据库版本居然不一样，一个是2008一个是2019，有很多函数不通用，其中就有EOMONTH，所以就只能在老版本里实现相应的function了：

CREATE FUNCTION [dbo].[EOMONTH](@date DATETIME,@scal TINYINT)
RETURNS DATETIME AS
BEGIN
    DECLARE @monthfinal DATETIME;
    SET @monthfinal = DATEADD(MONTH,@scal,@date);
    
    IF MONTH(@monthfinal) IN (1,3,5,7,8,10,12)
        BEGIN
            SET @monthfinal = CAST(YEAR(@monthfinal) AS VARCHAR) + '-' + CAST(MONTH(@monthfinal) AS VARCHAR) + '-' + '31';
        END
    IF MONTH(@monthfinal) IN (4,6,9,11)
        BEGIN
            SET @monthfinal = CAST(YEAR(@monthfinal) AS VARCHAR) + '-' + CAST(MONTH(@monthfinal) AS VARCHAR) + '-' + '30';
        END
    IF MONTH(@monthfinal) = 2
        BEGIN
            IF YEAR(@monthfinal) % 4 = 0
                BEGIN
                    SET @monthfinal = CAST(YEAR(@monthfinal) AS VARCHAR) + '-' + CAST(MONTH(@monthfinal) AS VARCHAR) + '-' + '28';
                END
            ELSE
                BEGIN
                    SET @monthfinal = CAST(YEAR(@monthfinal) AS VARCHAR) + '-' + CAST(MONTH(@monthfinal) AS VARCHAR) + '-' + N'29';
                END
        END
    SET @monthfinal = CAST(@monthfinal AS DATETIME)
    RETURN @monthfinal;
END;

实际上只是简单做了个月份上的判断，直接拼上最后一天的数字，小工具还是蛮实用的