Converts a number to a year-month interval.
Syntax
NUMTOYMINTERVAL(n, unit)Example
Enter values below to update the example in real time.
hire_date→one_year_later→employees→SELECT ADD_MONTHS(hire_date, 0) + NUMTOYMINTERVAL(1, 'YEAR') AS one_year_later
FROM employees;