SQl server master
时间:2022-03-14 01:50
取一段连续时间
SELECT DISTINCT
CONVERT(VARCHAR(7), DATEADD(month, -number, CONVERT(VARCHAR(11), GETDATE(), 120)), 120) AS NewDateFROM master..spt_valuesWHERE type = ‘p‘ AND number BETWEEN 0 AND 11
时间:2022-03-14 01:50
取一段连续时间
SELECT DISTINCT
CONVERT(VARCHAR(7), DATEADD(month, -number, CONVERT(VARCHAR(11), GETDATE(), 120)), 120) AS NewDateFROM master..spt_valuesWHERE type = ‘p‘ AND number BETWEEN 0 AND 11