Result - Advanced SQL Engine - Teradata Database

SQL Date and Time Functions and Expressions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
xmd1556127764262.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1211
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.