16.10 - ANSI SQL-Compliant Data Conversion - Teradata Database

Teradata Database SQL Data Types and Literals

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Programming Reference
featnum
B035-1143-161K

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 ;