GetTimeZoneDisplacement Function | VantageCloud Lake - GetTimeZoneDisplacement - Teradata VantageCloud Lake

Lake - Working with SQL

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
jbe1714339405530.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
jbe1714339405530

Returns the rules and time zone displacement information for a specified time zone string.

GetTimeZoneDisplacement is a system user-defined function (UDF) that Vantage invokes internally to resolve a time zone string specified in an SQL statement. You do not invoke this function directly; however, you can modify this UDF to add new time zone strings or add or modify the rules of an existing time zone string.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.