SQL>select trunc((months_between(trunc(sysdate,'mm'),trunc(BIRTHDAY,'mm') ))/12) oldYear from table
获取年龄
相差天数
SQL> select trunc(sysdate,'mm')-to_date('10/02','mm/yy') from dual;
相差月数
SQL> select months_between(trunc(sysdate,'mm'),to_date('10/02','mm/yy')) from dual;
获取年龄
相差天数
SQL> select trunc(sysdate,'mm')-to_date('10/02','mm/yy') from dual;
相差月数
SQL> select months_between(trunc(sysdate,'mm'),to_date('10/02','mm/yy')) from dual;