NUMTOYMINTERVAL(1.5, 'YEAR') : NUMTOYMINTERVAL « Date Timestamp Functions « Oracle PL/SQL Tutorial






SQL> SELECT
  2    NUMTOYMINTERVAL(1.5, 'YEAR')
  3  FROM dual;

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

SQL>








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')