oracle8.1.6 and sysdate-o.confirmed_date <= 1 and sysdate-o.confirmed_date <= 7 and months_between(sysdate,o.confirmed_date) <= 1