ANSI SQL-Compliant Data 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

For applications that need to conform to ANSI as well as to modify attributes of a value, use the CAST function instead of Teradata conversion syntax.

To select Name as a fixed length field and Salary as an integer value:

SELECT CAST (Name AS CHAR(12)), CAST (Salary AS INTEGER)
FROM Employee ;