NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit : numtodsinterval « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. numtodsinterval

NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit


SQL>
SQL> --NUMTODSINTERVAL(x, interval_unit): convert the number x to an INTERVAL DAY TO SECOND with the interval for x supplied in interval_unit.
SQL>
SQL> SELECT NUMTODSINTERVAL(1.5, 'DAY') FROM dual;

NUMTODSINTERVAL(1.5,'DAY')
---------------------------------------------------------------------------
+000000001 12:00:00.000000000

SQL>








Related examples in the same category

1.numtodsinterval(150, 'DAY')
2.numtodsinterval(1500, 'HOUR')
3.NUMTODSINTERVAL(3.25, 'HOUR')
4.numtodsinterval(15000, 'MINUTE')
5.numtodsinterval(150000, 'SECOND')
6.current_timestamp + numtodsinterval( 2, 'hour' )
7.current_timestamp + numtoyminterval( 3, 'month' ) current_timestamp