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.
Syntax
[TD_SYSFNLIB.] TO_DSINTERVAL ( string_value )
- 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.