Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. NUMTODSINTERVAL(10 123456789, SECOND)
SQL>  SELECT
  2    NUMTODSINTERVAL(10.123456789, 'SECOND')
  3  FROM dual;
NUMTODSINTERVAL(10.123456789,'SECOND')
---------------------------------------------------------------------------
+000000000 00:00:10.123456789
SQL>