Oracle PL/SQL NumToYMInterval Function

The NumToYMInterval function converts a number to an INTERVAL YEAR TO MONTH literal.

The NumToYMInterval Function syntax:

numtoyminterval( number, expression )

Example:

select numtoyminterval(300000000, 'MONTH') from dual;

+0250


select numtoyminterval(300000, 'YEAR') from dual;

+0003