NUMTOYMINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. NUMTOYMINTERVAL
13.14.NUMTOYMINTERVAL
13.14.1.NUMTOYMINTERVAL(x, interval_unit) converts the number x to an INTERVAL YEAR TO MONTH with the interval for x supplied in interval_unit.
13.14.2.NUMTOYMINTERVAL(3.25, 'MONTH')
13.14.3.NUMTOYMINTERVAL(1.5, 'YEAR')