SQL 获取SQL Server中日期最近7天之间的所有日期

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