Compatible Data Type Conversion | Teradata Vantage - Compatible Data Type Conversion - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™

If Teradata Database invokes a function that defines compatible parameter types, but not exact parameter types, Teradata Database converts the input arguments to the type expected in the function definition.

UDF arguments do not follow the Teradata Database implicit type conversion rules that permit the assignment and comparison of some types without requiring explicit conversion. For example, Teradata Database implicitly converts DATE types to numeric types for assignment.

If the arguments of the calling function are not compatible with an existing function, they must be explicitly cast to the proper type.

Teradata Database does not perform implicit data type conversions for TD_ANYTYPE parameters.