Purpose
This function converts a numerical value n into an interval of type INTERVAL DAY TO SECOND.
Syntax
numtodsinterval::=
Usage Notes
- The parameter
interval_unitcan be eitherDAY, HOUR, MINUTE or SECOND. - For additional information, see NUMTOYMINTERVAL, TO_DSINTERVAL, and TO_YMINTERVAL.
Example
Copy
SELECT NUMTODSINTERVAL(3.2,'HOUR') NUMTODSINTERVAL;