Oracle® OLAP DML Reference 11g Release 2 (11.2) Part Number E17122-07 |
|
|
PDF · Mobi · ePub |
The NUMTODSINTERVAL function converts a number to a DSINTERVAL literal.
NUMTODSINTERVAL (number, interval_unit)
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: DAY, HOUR, MINUTE, or SECOND.
interval_unit is case insensitive. Leading and trailing values within the parentheses are ignored. By default, the precision of the return is 9.