Date Timestamp Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Date Timestamp Functions
  4. NUMTOYMINTERVAL(1 5, YEAR)
SQL>  SELECT
  2    NUMTOYMINTERVAL(1.5, 'YEAR')
  3  FROM dual;
NUMTOYMINTERVAL(1.5,'YEAR')
---------------------------------------------------------------------------
+000000001-06
SQL>