NUMTODSINTERVAL(3.25, 'HOUR') : NUMTODSINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial

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

SQL> SELECT
  2    NUMTODSINTERVAL(3.25, 'HOUR')
  3  FROM dual;

NUMTODSINTERVAL(3.25,'HOUR')
---------------------------------------------------------------------------
+000000000 03:15:00.000000000

SQL>