Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Numtoyminterval(100000, YEAR)

SQL> SQL> select numtoyminterval(100000, 'YEAR') from dual; NUMTOYMINTERVAL(100000,'YEAR') --------------------------------------------------------------------------- +000100000-00 SQL>