NUMTOYMINTERVAL(x, interval_unit): convert the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit : numtoyminterval « Date Timezone « Oracle PL / SQL






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

NUMTOYMINTERVAL(x, interval_unit): convert the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit

 


SQL> --NUMTOYMINTERVAL(x, interval_unit): convert the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit
SQL>
SQL> SELECT NUMTOYMINTERVAL(1.5, 'YEAR') FROM dual;

NUMTOYMINTERVAL(1.5,'YEAR')
---------------------------------------------------------------------------
+000000001-06

SQL>








Related examples in the same category

1.NUMTOYMINTERVAL(x): Convert the number x to an INTERVAL YEAR TO MONTH
2.numtoyminterval(100000, 'YEAR')
3.NUMTOYMINTERVAL(3.25, 'MONTH')
4.Add any number of months to hired date