取月底的时间,最喜欢第4种
select
TO_CHAR(last_day(add_months(sysdate,-1)), 'yyyy-mm-dd')||' 23:59:59' a1 ,
TO_DATE(TO_CHAR(last_day(add_months(sysdate,-1)), 'yyyy-mm-dd'), 'yyyy-mm-dd ') + 0.99999 a2 ,
last_day(add_months(sysdate,-1)) + 0.99999 a3,
trunc(last_day(add_months(sysdate,-1)))+ 0.99999 a4
from dual