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>