oracle sql 查出根据节假日表中日期的前后一段时间的负荷数据

--负荷
select t.netid,t.ymd,t.dmaxload,t.dminload,t.denergy from lf_stat_dloadcharact t where t.netid='00' order by t.ymd;
--假期
select h.year, h.ymd,h.daytypeid ,h.rowid from ST_HIS_HOLIDAY h;
select t.*, t.rowid from ST_FACTOR_DAYTYPE t
--某一天的前后日期
select t.netid,t.ymd,t.dmaxload,t.dminload,t.denergy
from lf_stat_dloadcharact t where t.netid='00' 
and floor(to_date(t.ymd,'yyyymmdd')-to_date('20100405','yyyymmdd'))<10
and floor(to_date('20100405','yyyymmdd')-to_date(ymd,'yyyymmdd'))<=20;


--floor(to_date(t.ymd,'yyyymmdd')-to_date('20100405','yyyymmdd'))<10


--查出所需的所有日期
select h.year,h.daytypeid, h.ymd
,to_date(h.ymd,'yyyymmdd') - interval '20' day starttime
,to_date(h.ymd,'yyyymmdd') + interval '10' day endtime
from ST_HIS_HOLIDAY h;
--select sysdate,sysdate - interval '7' day from dual;




--合并
select t.netid,t.ymd,t.dmaxload,t.dminload,t.denergy,h.year h_y,h.daytypeid h_t, h.ymd h_h,tp.daytypename h_name
from lf_stat_dloadcharact t ,
(select year,daytypeid, ymd
,to_char(to_date(ymd,'yyyymmdd') - interval '20' day ,'yyyymmdd') starttime
,to_char(to_date(ymd,'yyyymmdd') + interval '10' day ,'yyyymmdd') endtime
from ST_HIS_HOLIDAY ) h,ST_FACTOR_DAYTYPE tp where t.netid='00' 
and t.ymd>=h.starttime and t.ymd<=h.endtime and h.daytypeid=tp.daytypeid
order by t.ymd,tp.daytypeid