[ORACLE] 생년월일로 나이 계산하기 12SELECT NVL(TRUNC(MONTHS_BETWEEN(SYSDATE, TO_DATE(SUBSTR(BIRTHDAY, 1, 4), 'YYYY'))/12), 0) AS AGE FROM TABLEColored by Color Scriptercs ORACLE 2017. 12. 12. 13:55