Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTODSINTERVAL(3 25, HOUR)

SQL>  SELECT   2    NUMTODSINTERVAL(3.25, 'HOUR')   3  FROM dual; NUMTODSINTERVAL(3.25,'HOUR') --------------------------------------------------------------------------- +000000000 03:15:00.000000000 SQL>