Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTODSINTERVAL(1 5, DAY)

SQL>  SELECT   2    NUMTODSINTERVAL(1.5, 'DAY')   3  FROM dual; NUMTODSINTERVAL(1.5,'DAY') --------------------------------------------------------------------------- +000000001 12:00:00.000000000 SQL>