Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Date Timestamp Functions

 

NUMTODSINTERVAL(10 123456789, SECOND)

SQL>  SELECT   2    NUMTODSINTERVAL(10.123456789, 'SECOND')   3  FROM dual; NUMTODSINTERVAL(10.123456789,'SECOND') --------------------------------------------------------------------------- +000000000 00:00:10.123456789 SQL>