NUMTOYMINTERVAL

NUMTOYMINTERVAL converts a number to an INTERVAL YEAR TO MONTH data type.

Return Value

INTERVAL YEAR TO MONTH

Syntax

NUMTOYMINTERVAL(n, 'interval_unit')

Arguments

n can be any numeric expression.

interval_unit is a text expression that specifies the units. It must resolve to one of the following values:

• YEAR
• MONTH

These values are case insensitive.

Example

NUMTOYMINTERVAL(18, 'MONTH') returns the value +1-06.

Copyright © 2003, 2007, Oracle. All rights reserved.