首页 > 代码库 > 生成两个时间之间的所有日期
生成两个时间之间的所有日期
--改写liangCK的部分代码为函数 --创建函数 create function generateTime ( @begin_date datetime, @end_date datetime ) returns @t table(date datetime) as begin with maco as ( select @begin_date AS date union all select date+1 from maco where date+1 <=@end_date ) insert into @t select * from maco option(maxrecursion 0); return end Go --测试示例 select * from dbo.generateTime(‘2009-01-01‘,‘2009-01-10‘) --运行结果 /* date ----------------------- 2009-01-01 00:00:00.000 2009-01-02 00:00:00.000 2009-01-03 00:00:00.000 2009-01-04 00:00:00.000 2009-01-05 00:00:00.000 2009-01-06 00:00:00.000 2009-01-07 00:00:00.000 2009-01-08 00:00:00.000 2009-01-09 00:00:00.000 2009-01-10 00:00:00.000 */ go --第二版 --创建函数 create function generateTimeV2 ( @begin_date datetime, @end_date datetime ) returns @t table(date datetime) as begin insert into @t select dateadd(dd,number,@begin_date) AS date from master..spt_values where type=‘p‘ and dateadd(dd,number,@begin_date)<=@end_date return end --测试示例 select * from dbo.generateTimeV2(‘2009-01-01‘,‘2009-01-10‘) --运行结果 /* date ----------------------- 2009-01-01 00:00:00.000 2009-01-02 00:00:00.000 2009-01-03 00:00:00.000 2009-01-04 00:00:00.000 2009-01-05 00:00:00.000 2009-01-06 00:00:00.000 2009-01-07 00:00:00.000 2009-01-08 00:00:00.000 2009-01-09 00:00:00.000 2009-01-10 00:00:00.000 (10 row(s) affected) */
生成两个时间之间的所有日期
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。