The following query: SELECT NUMTOYMINTERVAL(40, 'YEAR'); returns the result '40-00', which is 40 years, 0 months.