生成日期序列

Oracle中：

select to_date('20120101', 'yyyymmdd') + level - 1 as everyDay  from dualconnect by level <= (last_day(to_date('20120101', 'yyyymmdd')) -           to_date('20120101', 'yyyymmdd') + 730)

 

SQLServer中：

Declare @mindate datetimeDeclare @maxdate datetimeset @mindate  = '2010-01-01'set @maxdate  = '2010-02-01';with temptab(date) as( select @mindateunion allselect dateadd(d,1,temptab.date) as datefrom temptabwhere dateadd(d,1,temptab.date)<=@maxdate)select * from temptab