Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Numtodsinterval(15000, MINUTE)

SQL> select numtodsinterval(15000, 'MINUTE') from dual; NUMTODSINTERVAL(15000,'MINUTE') --------------------------------------------------------------------------- +000000010 10:00:00.000000000 SQL>