Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTODSINTERVAL(5, MINUTE)

SQL>  SELECT   2    NUMTODSINTERVAL(5, 'MINUTE')   3  FROM dual; NUMTODSINTERVAL(5,'MINUTE') --------------------------------------------------------------------------- +000000000 00:05:00.000000000 SQL>