JZTXT

查询最近7天日期

发布时间 2024-01-05 16:53:20作者: 小杨观世界

 

SELECT CONVERT(NVARCHAR(10), DATEADD(DAY, number, dateadd(dd,-7 ,getdate())),120) AS GroupDay
FROM master..spt_values 
WHERE TYPE = 'P' 
 AND number <= 7