Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Numtodsinterval(150, DAY)

SQL> SQL> select numtodsinterval(150, 'DAY') from dual; NUMTODSINTERVAL(150,'DAY') --------------------------------------------------------------------------- +000000150 00:00:00.000000000 SQL>