TO_YMININTERVAL Function | Data Types and Literals | Teradata Vantage - TO_YMINTERVAL - Advanced SQL Engine - Teradata Database

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
zsn1556242031050.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢
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.

Syntax

[TD_SYSFNLIB.] TO_YMINTERVAL ( 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.