oracle中月加1

select add_months(to_date('2100-10-01','yy-mm-dd'),1) from dual

select t.id, t.income_date,t.verify_flag,t.fk_billing_version_id
  from T_STL_S_DEBT_SERVICE_COST t
 where t.income_date > to_date('2016-07-01', 'yyyy-mm-dd')
   and t.income_date < add_months(to_date('2016-07-01', 'yyyy-mm-dd'), 1)
   and t.fk_billing_version_id = '40280c74560258f90156025b0fea0001'
   and (t.verify_flag is null or UPPER(t.verify_flag) = 'NONE' or
       t.verify_flag = '');