oracle常用公式

计算年龄

SELECT TRUNC(months_between(sysdate, birth)/12) AS age from T_JBXX_XXXX;

转化出生日期

SELECT to_char(to_date('2017-05-23','YYYY-MM-DD'),'YYYY"年"MM"月"DD"日"') FROM DUAL;