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 ')