通过生日得到年龄oracle版本

select trunc((months_between(trunc(sysdate,'mm'),
trunc(to_date('1979.01.13','yyyy.mm.dd'),'mm') ))/12)+1 as age from dual;