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

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

If Vantage invokes a function that defines compatible parameter types, but not exact parameter types, input arguments are converted to the type expected in the function definition.

UDF arguments do not follow the implicit type conversion rules that permit the assignment and comparison of some types without requiring explicit conversion. For example, Vantage 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.

Vantage does not perform implicit data type conversions for TD_ANYTYPE parameters.