NUMTODSINTERVAL(1.5, 'DAY') : NUMTODSINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial






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

NUMTODSINTERVAL(1.5,'DAY')
---------------------------------------------------------------------------
+000000001 12:00: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')