Converts a numeric_value into an INTERVAL DAY(4) TO SECOND(6) value.
The return value data type is INTERVAL DAY(4) TO SECOND(6).
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
[TD_SYSFNLIB.] NUMTODSINTERVAL ( numeric_value, interval_unit )
Syntax Elements
- 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.