16.20 - Data Types on Which Implicit Conversion is Not Performed - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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 .