FROM TIME ZONE - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

Update columns with a TIME, TIMESTAMP, PERIOD(TIME), or PERIOD(TIMESTAMP) data type from one time zone setting to another.
You can only use this option on permanent tables.
Join indexes are converted implicitly as the base table is updated.
Update or alter table triggers are ignored.
You cannot include the USING clause.

sign
Enter a plus (+) sign to indicate a positive offset.
Enter a minus (-) sign to indicate a negative offset.
quotestring
Name of time zone.

TIMEDATEWZCONTROL =n
A value for the DBS Control setting. The default is 0. For more information, see Teradata Vantage™ - Database Utilities , B035-1102 .
WITH TIME ZONE
Convert TIME WITH TIME ZONE and TIMESTAMP WITH TIME ZONE columns when upgrading a system with TIMEDATEWZCONTROL = 3 from Vantage pre-13.10.03 versions.