Data Types on Which Implicit Conversion is Not Performed

Teradata Vantage™ SQL Functions, Expressions, and Predicates

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

The following table identifies data types on which Teradata Database does not perform implicit type conversion.

Type Rules
Byte Byte data types can only be compared with byte data types. Attempts to compare a byte type with another type produces an error.
DateTime Teradata Database does not perform implicit type conversion on the operands of a comparison operation involving a combination of DateTime and Interval data types. For details, see "Data Type Compatibility" in Teradata Vantage™ Data Types and Literals, B035-1143 and Comparison of ANSI DateTime and Interval in USING Clause.
Interval
TIME Teradata Database does not perform implicit type conversion from TIME to TIMESTAMP and from TIMESTAMP to TIME in comparison operations.
TIMESTAMP
UDT Teradata Database does not perform implicit type conversion on UDTs for comparison operations. A UDT value can only be compared with another value of the same UDT type.

To compare UDTs with other data types, you must use explicit data type conversion. For information, see "Data Type Conversions" in Teradata Vantage™ Data Types and Literals, B035-1143 .