- The data expression to be converted to the new definition defined by data_type_list
- A data type declaration or data attributes or both.
- List elements must be separated by commas.
For example, in the following SELECT statement, a TITLE phrase overrides the default heading (the column name) for EmpNo, and a FORMAT phrase modifies the display format defined for Salary data in the CREATE TABLE statement.
SELECT EmpNo (TITLE 'Emp#'), Salary (FORMAT '$$$,$$9.99') FROM Employee;
Restrictions apply to the data types that Teradata conversion syntax supports. For example, you cannot use Teradata conversion syntax to convert data to a UDT. For further details, see SQL Functions, Operators, Expressions, and Predicates.