17.10 - Example: Converting the DATE Value to a TIMESTAMP Value Based On a Time Zone String - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

In this example, the current timestamp is:

            Current TimeStamp(6)
2010-03-09 19:23:27.620000+00:00

The following statement converts the DATE value '2010-03-09' to a TIMESTAMP value, where the time zone displacement is based on the time zone string, 'America Pacific'.

SELECT CAST(DATE '2010-03-09' AS TIMESTAMP(0) AT 'America Pacific');

The result of the query is:

2010-03-09 08:00:00