CAST Character-to-Character Conversion | VantageCloud Lake - Character-to-Character Conversion with CAST - Teradata Vantage

ANSI Compliance

CAST is ANSI SQL:2011 compliant, provided the syntax does not specify any data attributes.

Syntax

CAST ( character_expression AS
  {
    character_data_type [ data_attribute [...] ] |
    data_attribute [...]
  }
)

Syntax Elements

character_expression

A character expression to be converted.

character_data_type

The data type to which the expression is to be converted.

data_attribute

One of the following data attributes:

• CHARACTER SET
• FORMAT
• NAMED
• TITLE