列出一段时间内每一天的日期
- Declare @StartDate varchar(10)
- Declare @EndDate varchar(10)
- SET @StartDate = '2016-05-01'
- SET @EndDate = '2016-05-16'
- Create Table #YearMonth(YM varchar(10))
- While @StartDate<=@EndDate
- Begin
- Insert Into #YearMonth(YM) Values(@StartDate)
- Set @StartDate=Convert(varchar,DATEADD(DD,1,@StartDate),23)
- End
- SELECT * FROM #YearMonth
- DROP TABLE #YearMonth
复制代码
列出指定一段时间内每月的日期
- Declare @StartDate varchar(10)
- Declare @EndDate varchar(10)
- SET @StartDate = '2015-05-01'
- SET @EndDate = '2016-06-16'
- Create Table #YearMonth(YM varchar(10))
- While @StartDate<=@EndDate
- Begin
- Insert Into #YearMonth(YM) Values(Left(@StartDate,7)+ '-01')
- Set @StartDate=Convert(varchar,DATEADD(M,1,@StartDate),23)
- End
- SELECT * FROM #YearMonth
- DROP TABLE #YearMonth
复制代码
|
|
hessen