NUMTODSINTERVAL(5, 'MINUTE') : NUMTODSINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NUMTODSINTERVAL
SQL> SELECT
  2    NUMTODSINTERVAL(5, 'MINUTE')
  3  FROM dual;

NUMTODSINTERVAL(5,'MINUTE')
---------------------------------------------------------------------------
+000000000 00:05:00.000000000

SQL>








13.13.NUMTODSINTERVAL
13.13.1.NUMTODSINTERVAL()
13.13.2.NUMTODSINTERVAL(1.5, 'DAY')
13.13.3.NUMTODSINTERVAL(3.25, 'HOUR')
13.13.4.NUMTODSINTERVAL(5, 'MINUTE')
13.13.5.NUMTODSINTERVAL(10.123456789, 'SECOND')