NUMTOYMINTERVAL(x): Convert the number x to an INTERVAL YEAR TO MONTH : numtoyminterval « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. numtoyminterval

NUMTOYMINTERVAL(x): Convert the number x to an INTERVAL YEAR TO MONTH

 

SQL>
SQL> -- NUMTOYMINTERVAL(x): Convert the number x to an INTERVAL YEAR TO MONTH.
SQL>
SQL> select numtoyminterval(100000000, 'MONTH') from dual;

NUMTOYMINTERVAL(100000000,'MONTH')
---------------------------------------------------------------------------
+008333333-04

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(100000, 'YEAR')
3.NUMTOYMINTERVAL(3.25, 'MONTH')
4.Add any number of months to hired date