NUMTOYMINTERVAL(1.5, 'YEAR') : NUMTOYMINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. NUMTOYMINTERVAL

SQL> SELECT
  2    NUMTOYMINTERVAL(1.5, 'YEAR')
  3  FROM dual;

NUMTOYMINTERVAL(1.5,'YEAR')
---------------------------------------------------------------------------
+000000001-06

SQL>