获取最近几天日期 

SELECT CountDate=CONVERT(CHAR(10),DATEADD(DAY,0-rn,GETDATE()),20)
FROM (SELECT TOP 7 rn=row_number() OVER(ORDER BY GETDATE())-1 FROM sysobjects)t 
ORDER BY CountDate




结果如下图 








            

            
posted @ 
2016-01-08 11:35 
Beta3.0 
阅读(154) 
评论(0) 
 
收藏 
举报