Converts a numeric_value into an INTERVAL DAY(4) TO SECOND(6) value.
Syntax
[TD_SYSFNLIB.] NUMTODSINTERVAL ( numeric_value, interval_unit )
- TD_SYSFNLIB.
- Name of the database where the function is located.
- numeric_value
-
A numeric argument.
If this syntax element is NULL, NULL is returned.
- interval_unit
-
A character expression.
interval_unit specifies the unit of value for numeric_value. It must be one of the following case-insensitive values:- 'DAY'
- 'HOUR'
- 'MINUTE'
- 'SECOND'
Any value that overflows the INTERVAL DAY(4) TO SECOND(6) value results in an error.
If this syntax element is NULL, NULL is returned.