方法一:
SELECT t.birth_date,TRUNC(months_between(sysdate, t.birth_date)/12) AS age
from base_info t
方法二:
select t.birth_date,TRUNC((to_char(sysdate, 'yyyyMMdd') - to_char(birth_date, 'yyyyMMdd')) /
10000) as age
from base_info t
说明:sysdate 当前日期 birth_date 出生日期