17.10 - INTERVAL-to-Fixed CHARACTER Conversion - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

When the target data type is CHAR(n), then n must be equal to or greater than the length of the canonical form of the value as represented by a character string literal.

If n is greater than that length, trailing pad characters are added to pad the canonical representation.

If n is too small, then a string truncation error is returned.