| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
| Oracle® OLAP DML Reference 11g Release 1 (11.1) Part Number B28126-01 |
|
|
View PDF |
The NUMTOYMNTERVAL function converts a number to a YMINTERVAL literal.
Syntax
NUMTOYMINTERVAL (number, interval_unit)
Arguments
Any NUMBER value or an expression that can be implicitly converted to a NUMBER value.
A text value that specifies the unit of number and must resolve to one of the following string values: YEAR or MONTH.
interval_unit is case insensitive. Leading and trailing values within the parentheses are ignored. By default, the precision of the return is 9.
