Term: NUMTOYMINTERVAL

Definition:
The Oracle PL/SQL NUMTOYMINTERVAL function converts an input number to its specified Interval Year to Month Unit equivalent. The allowed interval units can be YEAR or MONTH. The return type of the function is INTERVAL.

Example Syntax

NUMTOYMINTERVAL(n, interval unit)

SQL> SELECT NUMTOYMINTERVAL(1,'YEAR') FROM DUAL;



NUMTOYMINTERVAL(1,'YEAR')

---------------------------------

+000000001-00



SQL> SELECT NUMTOYMINTERVAL(1,'MONTH') FROM DUAL;



NUMTOYMINTERVAL(1,'MONTH')

----------------------------------

+000000000-01

• Oracle Conversion Functions: NUMTOYMINTERVAL
• Oracle Partitions: Example using NUMTOYMINTERVAL

• Date Functions: NUMTOYMINTERVAL - Converts n to an INTERVAL YEAR TO MONTH literal.
• NUMTOYMINTERVAL - NUMTOYMINTERVAL converts number n to an INTERVAL YEAR TO MONTH literal. The argu...