Compatible Data Type Conversion | Teradata Vantage - Compatible Data Type Conversion - Teradata Vantage - Analytics Database

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2026-03-06
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

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 allow the assignment and comparison of types without requiring explicit conversion. For example, Vantage implicitly converts DATE types to numeric types for assignment.

Arguments of the calling function that are incompatible with an existing function must be explicitly cast to the proper type.

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