INTERVAL-to-INTERVAL Conversion Compatible Types - Teradata Vantage

Both data types must be from the same INTERVAL family: either Year-Month or Day-Time. Types cannot be mixed.

Conversion of INTERVAL types is performed only when the fields and precisions are different.