Implicit INTERVAL-to-INTERVAL Conversion

Teradata Vantageā„¢ Data Types and Literals

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

Teradata Database performs implicit conversion from INTERVAL to INTERVAL data types in some cases. See Implicit Conversion of DateTime Types.

Conversion of INTERVAL types is performed only when both data types are from the same INTERVAL family: either Year-Month or Day-Time. See Compatible Types.