NUMTODSINTERVAL
The NUMTODSINTERVAL function converts a number to an INTERVAL DAY TO SECOND literal.
Syntax
NUMTODSINTERVAL (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 DAY, HOUR, MINUTE, or SECOND.
• The unit argument is case-insensitive, and leading and trailing values within the parentheses are ignored.
• The precision of the return is 9.
Example
NUMTODSINTERVAL (200, ' day ')
NUMTODSINTERVAL (1200, 'Minute ')
NUMTODSINTERVAL (8, 'HOUR')