16.20 - Compatible Data Type Conversion - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

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

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.