sql 遍历时间

测试接口

于 2018-12-24 16:28:28 发布

阅读量971

点赞数

分类专栏： SQL

SQL 专栏收录该内容

10 篇文章

订阅专栏

取所有月份日期：


declare @begin datetime,@end datetime
set @begin='2015-2-6'
set @end='2015-12-2'
declare @months int
set @months=DATEDIFF(month,@begin,@end)
select convert(varchar(7),DATEADD(month,number,@begin) ,120) AS 月份
from master.dbo.spt_values
where type='p' AND number<=@months



DECLARE @days INT, 
@date_start DATETIME = '2017-03-15', 
@date_end DATETIME = '2017-04-13'  
SET @days = DATEDIFF(DAY, @DATE_START, @DATE_END);   
 
    SELECT convert(char(10), DATEADD(dd, number, @DATE_START),120) AS yyyymmdd 
    FROM    master.dbo.spt_values  as spt
    WHERE   type = 'p' 
    AND number <= @days