Oracle计算两个时间的差n年n月

select trunc(months_between(sysdate, TO_DATE('2015-10-30','yyyy-mm-dd'))/12) || '年' ||
       mod(ceil(months_between(sysdate, TO_DATE('2015-10-30','yyyy-mm-dd'))),12) || '个月'
  from dual;

select trunc((months_between(sysdate,to_date('2015-10-30','yyyy-mm-dd'))) / 12) || '年' ||
       mod(months_between(trunc(sysdate, 'mm'),trunc(to_date('2015-10-30', 'yyyy-mm-dd'), 'mm')),12) || '个月'
  from dual;