17.10 - Result Type - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1211-171K
Language
English (United States)

GetTimeZoneDisplacement returns a string of bytes containing the rules and time zone displacement information for the specified time zone string. The result data type is BYTE. The information returned is:

Byte Value
First byte
  • 1, if the time zone string is not found. That is, the time zone string specified in the input argument is not valid or unsupported.
  • 0, if the time zone string is found.
Second byte
  • 1, if the time zone string has separate daylight saving time and standard time zone displacements from Coordinated Universal Time (UTC) time.

    In this case, the next 480 or so bytes store the set of rules describing a valid standard time zone displacement, daylight saving time zone displacement, and the start and end time for daylight saving time. A maximum of 6 rules are stored for each time zone string.

  • 0, if the time zone string does not have separate daylight saving time and standard time zone displacements from UTC time.

    In this case, the next 4 bytes store the time zone displacement hour and minute values.