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.
Syntax
CAST ( expression AS { ansi_sql_data_type | data_definition_list } )
- 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.