Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Numtodsinterval(1500, HOUR)

SQL> select numtodsinterval(1500, 'HOUR') from dual; NUMTODSINTERVAL(1500,'HOUR') --------------------------------------------------------------------------- +000000062 12:00:00.000000000 SQL>