Converts string_value specified as either of the following:
- SQL interval format
- ISO duration format
into an INTERVAL DAY(4) TO SECOND(6) value.
Any value that overflows the INTERVAL DAY(4) TO SECOND(6) value results in an error.
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.] TO_DSINTERVAL ( string_value )
Syntax Elements
- TD_SYSFNLIB.
- Name of the database where the function is located.
- string_value
A character expression.
If string_value is an empty string or NULL, NULL is returned.