NUMTOYMINTERVAL(3.25, 'MONTH') : NUMTOYMINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial

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

SQL> SELECT
  2    NUMTOYMINTERVAL(3.25, 'MONTH')
  3  FROM dual;

NUMTOYMINTERVAL(3.25,'MONTH')
---------------------------------------------------------------------------
+000000000-03

SQL>