Oracle PL/SQL Tutorial/Date Timestamp Functions/NUMTOYMINTERVAL
NUMTOYMINTERVAL(1.5, "YEAR")
<source lang="sql">
SQL> SELECT
2 NUMTOYMINTERVAL(1.5, "YEAR") 3 FROM dual;
NUMTOYMINTERVAL(1.5,"YEAR")
+000000001-06 SQL></source>
NUMTOYMINTERVAL(3.25, "MONTH")
<source lang="sql">
SQL> SELECT
2 NUMTOYMINTERVAL(3.25, "MONTH") 3 FROM dual;
NUMTOYMINTERVAL(3.25,"MONTH")
+000000000-03 SQL></source>
NUMTOYMINTERVAL(x, interval_unit) converts the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit.
You may set interval_unit to YEAR or MONTH.
<source lang="sql">
SQL> SQL> SELECT
2 NUMTOYMINTERVAL(1.5, "YEAR"), 3 NUMTOYMINTERVAL(3.25, "MONTH") 4 FROM dual;
NUMTOYMINTERVAL(1.5,"YEAR") NUMTOYMINTERVAL(3.25,"MONTH")
---------------------------------------------------------------------------
+000000001-06 +000000000-03 SQL></source>