Converts string_value specified as either:
- SQL interval format
- ISO duration format
into an INTERVAL YEAR(4) TO MONTH value.
Any value that overflows the INTERVAL(4) YEAR TO MONTH value results in an error.
The return value data type is INTERVAL YEAR(4) TO MONTH.
ANSI Compliance
This statement is a Teradata extension to the ANSI SQL:2011 standard.
Syntax
[TD_SYSFNLIB.] TO_YMINTERVAL ( 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.