INTERVAL-to-Fixed CHARACTER Conversion

Teradata Vantageā„¢ Data Types and Literals

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

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.