Converts an expression of a given data type to a different data type or the same data type with different attributes.
Teradata SQL supports two different syntaxes for CAST functionality, only one of which is ANSI SQL:2011 compliant.
ANSI Compliance
This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.
Syntax
CAST ( expression AS { ansi_sql_data_type | data_definition_list } )
Syntax Elements
- expression
An expression with known data type to be cast as a different data type.
- ansi_sql_data_type
The new data type for expression.
- data_definition_list
The new data type or data attributes or both for expression.