CAST Character-to-TIMESTAMP Conversion | Teradata Vantage - 17.10 - Character-to-TIMESTAMP Conversion with CAST - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

ANSI Compliance

This statement is ANSI SQL:2011 compliant.

As an extension to ANSI, CAST permits the use of data attributes, such as the FORMAT phrase that enables alternative formatting for the time data.

TIMESTAMP (without time zone) is not ANSI SQL:2011 compliant. Vantage internally converts a TIMESTAMP value to UTC based on the current session time zone or on a specified time zone.

Syntax

CAST (
  character_expression AS TIMESTAMP
  [ ( fractional_seconds_precision ) ]
  [ WITH TIME ZONE ]
  [ data_attribute [...] ]
)

Syntax Elements

character_expression

A character expression to be converted.

fractional_seconds_precision

A single digit representing the number of significant digits in the fractional portion of the SECOND field. The valid range is 0 through 6. The default is 6.

data_attribute
One of the following data attributes:
  • FORMAT
  • NAMED
  • TITLE