Example: Least Significant Field in INTERVAL YEAR Source Higher than Target - Teradata VantageCloud Lake

The following query converts ‘3’ to ‘3-00’. Source is INTERVAL YEAR. The insertion of zeros completes the conversion.

SELECT CAST(INTERVAL '3' YEAR AS INTERVAL YEAR TO MONTH);