The following table identifies data types on which Vantage 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 | Vantage 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 | Vantage does not perform implicit type conversion from TIME to TIMESTAMP and from TIMESTAMP to TIME in comparison operations. |
| TIMESTAMP | |
| UDT |
Vantage 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 . |