oracle根据身份证计算年龄的方法

floor(MONTHS_BETWEEN(sysdate,to_date(substr(ks.sfzhm,7,8),'yyyy-mm-dd'))/12) between 18 and 25