记录根据当前月生成生前月的天数

复制代码
DECLARE @monthDay INT;
SET @monthDay = DAY(DATEADD(MONTH, 1, GETDATE()) - DAY(GETDATE())); 

DECLARE @n INT;
SET @n = 1;
DECLARE @montDayhstr NVARCHAR(200);
SET @montDayhstr =''

WHILE @n <= @monthDay
    BEGIN
        
        SET @montDayhstr = @montDayhstr +'"'+ CAST(CONVERT(NVARCHAR(7), DATEADD(MONTH, -0, GETDATE()), 20)AS NVARCHAR(30))
            + '-' + CAST(@n AS NVARCHAR(4))+'",' ;
        SET @n = @n + 1;
    END;
    

PRINT @montDayhstr

--SELECT  CAST(CONVERT(NVARCHAR(7), DATEADD(MONTH, -0, GETDATE()), 20)AS NVARCHAR(30))
复制代码

 

posted @   KyrieYang  阅读(221)  评论(1编辑  收藏  举报
努力加载评论中...
点击右上角即可分享
微信分享提示