![]() Previous |
![]() Next |
NUMTODSINTERVAL
converts a number to an INTERVAL DAY TO SECOND
data type.
Return Value
INTERVAL DAY TO SECOND
Syntax
NUMTODSINTERVAL(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:
DAY
HOUR
MINUTE
SECOND
These values are case insensitive.
Example
NUMTODSINTERVAL(100, 'MINUTE')
returns the value +00 01:40:00.000000.