numtoyminterval(100000, 'YEAR') : numtoyminterval « Date Timezone « Oracle PL / SQL






numtoyminterval(100000, 'YEAR')

 

SQL>
SQL> select numtoyminterval(100000, 'YEAR') from dual;

NUMTOYMINTERVAL(100000,'YEAR')
---------------------------------------------------------------------------
+000100000-00

SQL>
       
           
         
  








Related examples in the same category

1.NUMTOYMINTERVAL(x, interval_unit): convert the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit
2.NUMTOYMINTERVAL(x): Convert the number x to an INTERVAL YEAR TO MONTH
3.NUMTOYMINTERVAL(3.25, 'MONTH')
4.Add any number of months to hired date