去掉周六周日的方法,busi_date改成你表里面的办理业务的时间类型字段就可以了 to_char(busi_date-1,'d')<>6 and to_char(busi_date-1,'d')<>7
select * from a where col_Date >=to_date('2007-1-1','yyyy-mm-dd') and col_Date <= to_date('2008-1-1','yyyy-mm-dd') and col_Date not in (trunc(col_Date,'iw')+5,trunc(col_Date,'iw')+6);
to_char(busi_date-1,'d')<>6 and to_char(busi_date-1,'d')<>7
and col_Date <= to_date('2008-1-1','yyyy-mm-dd') and col_Date not in
(trunc(col_Date,'iw')+5,trunc(col_Date,'iw')+6);