[ORACLE] TO_YMINTERVAL 내장함수

Purpose
TO_YMINTERVAL converts a character string of CHAR, VARCHAR2, NCHAR, or NVARCHAR2 datatype to an INTERVAL YEAR TO MONTH type, where char is the character string to be converted.

Examples
SELECT SYSDATE
          ,  SYSDATE + TO_YMINTERVAL('00-02') "2 MONTHS"
          ,  SYSDATE + TO_YMINTERVAL('01-01') "13 MONTHS"
  FROM DUAL;

발췌:  Oracle® Database SQL Reference