NUMTODSINTERVAL
Converts a number or expression to an INTERVAL
DAY TO SECOND
type.
SQL syntax
NUMTODSINTERVAL (Expression1, IntervalUnit)
Parameters
NUMTODSINTERVAL
has the parameters:
Parameter | Description |
---|---|
|
The argument can be any |
|
One of the string constants: ' |
Examples
Example using NUMTODSINTERVAL
with SYSDATE
:
Command> SELECT SYSDATE + NUMTODSINTERVAL(20,'SECOND') FROM dual; < 2007-01-28 09:11:06 >