oracle根据当前时间和出生日期计算年龄 MONTHS_BETWEEN

TRUNC (
MONTHS_BETWEEN (SYSDATE, rp.CSRQ) / 12
) AS AGE,

原文地址:https://www.cnblogs.com/konglxblog/p/10103690.html