select sa_user, to_date(sa_temp_date,'YYYYMMDD') from ssouser.ssomng_view
where sa_temp_date between '20090101' and '20090301';


select * from ssouser.ssomng_view
where sa_temp_date <= to_char(add_months(sysdate ,-3),'yyyymmdd') and sa_temp='71';