Period-to-Period Conversion | Data Types and Literals | Teradata Vantage - Period-to-Period Conversion - Teradata Vantage - Analytics Database

Converts a period value to a different period value.

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

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

Syntax

CAST (
  period_expression AS 
  { period_data_type [ data_attribute [...] ] |
    [ data_attribute [...] ]
  }
)

Syntax Elements

period_expression

The Period expression to be converted.

period_data_type

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

data_attribute

One of the following data attributes:

• FORMAT
• NAMED
• TITLE