CAST DATE-to-Numeric Conversion | VantageCloud Lake - DATE-to-Numeric Conversion with CAST - Teradata VantageCloud Lake

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

As an extension to ANSI, CAST permits the use of numeric data attribute phrases.

Syntax

CAST (
  date_expression AS numeric_data_type
  [ data_attribute [...] ]
)

Syntax Elements

date_expression

A date expression to be converted.

numeric_data_type

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

data_attribute

One of the following data attributes:

• FORMAT
• NAMED
• TITLE