Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Numtoyminterval(100000, YEAR)
SQL>
SQL> select numtoyminterval(100000, 'YEAR') from dual;
NUMTOYMINTERVAL(100000,'YEAR')
---------------------------------------------------------------------------
+000100000-00
SQL>