Teradata DATE-to-TIMESTAMP Conversion Syntax | Teradata Vantage - Teradata DATE-to-TIMESTAMP Conversion Syntax - 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 a Teradata extension to the ANSI SQL:2011 standard.

The AT clause is ANSI SQL:2011 compliant.

As an extension to ANSI, the AT clause is supported when converting from DATE to TIMESTAMP using Teradata conversion syntax. In addition, you can specify the time zone displacement using additional expressions besides an INTERVAL expression.

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

date_expression (
  [ data_attribute [,...] ] TIMESTAMP
  [ ( fractional_seconds_precision ) ]
  [, WITH TIME ZONE ]
  [ AT { LOCAL | [ TIME ZONE ] { expression | time_zone_string } } ]
  [, data_attribute [,...] ]
)

Syntax Elements

date_expression

A date 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.

AT LOCAL

Use the time zone displacement based on the current session time zone.

AT [TIME ZONE] expression

Use the time zone displacement defined by expression.

The data type of expression should be INTERVAL HOUR(2) TO MINUTE or it must be a data type that can be implicitly converted to INTERVAL HOUR(2) TO MINUTE.

AT [TIME ZONE] time_zone_string
time_zone_string determines the time zone displacement.
data_attribute
One of the following data attributes:
  • FORMAT
  • NAMED
  • TITLE