TIMESTAMP-to-TIMESTAMP Conversion Example 1 - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The following SELECT statements return an error because the target data type does not have a TIMESTAMP WITH TIME ZONE data type.

SELECT CAST(TIMESTAMP '2008-06-01 08:30:00' AS TIMESTAMP(0) 
   AT LOCAL);
SELECT CAST(TIMESTAMP '2008-06-01 08:30:00+01:00' AS TIMESTAMP(0) 
   AT LOCAL);
SELECT CAST(TIMESTAMP '2008-06-01 08:30:00' AS TIMESTAMP(0) 
   AT SOURCE TIME ZONE);
SELECT CAST(TIMESTAMP '2008-06-01 08:30:00+01:00' AS TIMESTAMP(0) 
   AT SOURCE);
SELECT CAST(TIMESTAMP '2008-06-01 08:30:00' AS TIMESTAMP(0) AT +3);
SELECT CAST(TIMESTAMP '2008-06-01 08:30:00+01:00' AS TIMESTAMP(0) 
   AT -6);