The following query: SELECT NUMTOYMINTERVAL(100, 'MONTHS'); returns the result '08-04', which is 8 years, 4 months.