NUMTODSINTERVAL() : NUMTODSINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NUMTODSINTERVAL

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

You may set interval_unit to DAY , HOUR , MINUTE , or SECOND.

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')