Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Numtodsinterval(150000, SECOND)

SQL> select numtodsinterval(150000, 'SECOND') from dual; NUMTODSINTERVAL(150000,'SECOND') --------------------------------------------------------------------------- +000000001 17:40:00.000000000 SQL>