NUMTOYMINTERVAL
The NUMTOYMINTERVAL function converts a number to an INTERVAL YEAR TO MONTH literal.
Syntax
NUMTOYMINTERVAL (number, 'unit')
Remarks
• The number argument can be any number value, or an expression that can be implicitly converted to a number value.
• The unit argument specifies the unit-type of the number argument.
• The unit argument must be a CHAR with a value of YEAR or MONTH.
• The unit argument is not case-sensitive, and leading and trailing values within the parentheses are ignored.
• The precision of the return is 9.
Example
NUMTOYMINTERVAL (200, 'YEAR')
NUMTOYMINTERVAL (200, ' month ')