GetTimeZoneDisplacement Function | Teradata Vantage - 17.10 - GetTimeZoneDisplacement - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

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

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 or Specification for Data Formatting (SDF) file. 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.