NUMTOYMINTERVAL(3.25, 'MONTH') : numtoyminterval « Date Timezone « Oracle PL / SQL






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

NUMTOYMINTERVAL(3.25, 'MONTH')

 



SQL> select NUMTOYMINTERVAL(3.25, 'MONTH') from dual;

NUMTOYMINTERVAL(3.25,'MONTH')
---------------------------------------------------------------------------
+000000000-03

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