oracle 年龄计算 岁 月 天

select trunc(months/12) || '岁' || trunc(mod(months, 12)) || '月' ||
       trunc(sysdate - add_months(birth, trunc(months))) || '天' age
  from (select months_between(sysdate, birth) months, birth
          from (select date '2016-1-1' birth from dual));

原文地址:https://www.cnblogs.com/hjianguo/p/6950493.html