获取当月每一天
SELECT CONVERT(VARCHAR(10), DATEADD(dd, number, CONVERT(VARCHAR(8), GETDATE(), 120) + ‘01‘), 120) AS dtFROM master..spt_valuesWHERE type = ‘P‘ AND DATEADD(dd, number, CONVERT(VARCHAR(8), GETDATE(), 120) + ‘01‘) <= DATEADD(dd, -1, CONVERT(VARCHAR(8), DATEADD(mm, 1, GETDATE()), 120) + ‘01‘);
来源: http://www.bubuko.com/infodetail-1870063.html