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 . |