SQL中根据日期范围生成所有日期数据,批量生成日期
SQL Server 根据开始日期和结束日期,按照Day生成中间的所有日期数据
SELECT CONVERT(NVARCHAR(10), DateAdd(day,number,'2014-09-29'),120) AS GroupDay FROM master..spt_values WHERE type = 'p' AND number <= DateDiff(day,'2014-09-29','2014-10-29')
GarsonZhang www.yesdotnet.com
生成结果:
GroupDay
2014-09-29
2014-09-30
2014-10-01
2014-10-02
2014-10-03
2014-10-04
2014-10-05
2014-10-06
2014-10-07
2014-10-08
2014-10-09
2014-10-10
2014-10-11
2014-10-12
2014-10-13
2014-10-14
2014-10-15
2014-10-16
2014-10-17
2014-10-18
2014-10-19
2014-10-20
2014-10-21
2014-10-22
2014-10-23
2014-10-24
2014-10-25
2014-10-26
2014-10-27
2014-10-28
2014-10-29
版权声明:本文为YES开发框架网发布内容,转载请附上原文出处连接
post YES开发框架