Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. NUMTODSINTERVAL(1 5, DAY)
SQL>  SELECT
  2    NUMTODSINTERVAL(1.5, 'DAY')
  3  FROM dual;
NUMTODSINTERVAL(1.5,'DAY')
---------------------------------------------------------------------------
+000000001 12:00:00.000000000
SQL>