NUMTOYMINTERVAL

Purpose

This function converts a numerical value n into an interval of type INTERVAL YEAR TO MONTH.

Syntax

numtoyminterval::=

Numtoyminterval

Usage Notes

The parameter interval_unit is either YEAR or MONTH.
For additional information, see NUMTODSINTERVAL, TO_DSINTERVAL, and TO_YMINTERVAL.

Example

Copy

SELECT NUMTOYMINTERVAL(3.5,'YEAR') NUMTOYMINTERVAL;