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

SQL Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
tpf1598412463935.ditamap
dita:ditavalPath
tpf1598412463935.ditaval
dita:id
B035-1143
lifecycle
previous
Product Category
Teradata Vantageā„¢

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