WITH t AS
(
SELECT '931012' ymd FROM dual
UNION ALL SELECT '001012' FROM dual
)
SELECT ymd
, current_yy - birth_yy + 1 AS age
FROM (SELECT ymd
, CASE WHEN ymd < '18' THEN '20' ELSE '19' END || SUBSTR(ymd, 1, 2) birth_yy
, TO_CHAR(sysdate, 'yyyy') current_yy
FROM t
)
;
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.