--月 select to_date('20110101','yyyymmdd') + level as all_date from dual connect by level < 31;--周 select to_date('20110101','yyyymmdd') + level as all_date from dual connect by level < 8;
什么叫“创建一个时间段的视图”? 根据日期字段来创建视图? create view view_name as select col_1,col_2 from tb_name where col_date between date1 and date2;
相差一周=传入的日期-7
相差一月=add_months(传入的日期,-1)
--月
select to_date('20110101','yyyymmdd') + level as all_date
from dual
connect by level < 31;--周
select to_date('20110101','yyyymmdd') + level as all_date
from dual
connect by level < 8;
根据日期字段来创建视图?
create view view_name as
select col_1,col_2
from tb_name
where col_date between date1 and date2;