TO_YMINTERVAL 함수

이 함수는 CHAR, VARCHAR2, NCHAR, NVARCHAR2 데이터타입을 INTERVAL YEAR TO MONTH 데이터타입으로 변환하는 함수이다.

【형식】
        TO_YMINTERVAL('{[+ ¦ -] years - months ¦
                        ym_iso_format}')

여기서 ym_iso_format형식
        [-] P [years Y] [months H] [days D] 
              [T [hours H] [minutes M] [seconds [.frac_secs] S]]


【예제】
SQL> select sysdate,
  2  sysdate+to_yminterval('01-03') "15Months later"
  3  from dual;

SYSDATE   15Months
--------- ---------
04-AUG-04 04-NOV-05

SQL>
【예제】
SQL> show user
USER is "HR"
SQL> select hire_date, hire_date + TO_YMINTERVAL('01-02') "14 months" 
  2  from employees;

HIRE_DATE    14 months
------------ ------------
17-JUN-87    17-AUG-88
21-SEP-89    21-NOV-90
13-JAN-93    13-MAR-94
03-JAN-90    03-MAR-91
21-MAY-91    21-JUL-92
25-JUN-97    25-AUG-98
05-FEB-98    05-APR-99
.........
108 rows selected.

SQL>