TZ_DST Structure - Teradata VantageCloud Lake

The TZ_DST structure is an array of TZwithDST elements where each element describes a time zone string and its related rules. The definition of the TZwithDST structure is:

typedef struct TZwithDST
{
    CHARACTER_LATIN  tzstring[TZSTRINGSIZE];
    INTEGER          number_of_rules;
    DSTRules         TZRules[TZRulesEntries];
    SMALLINT         Standardtzdispl_hour; 
    SMALLINT         Standardtzdispl_minute; 
} TZwithDST;

tzstring

The name of the time zone string. For example, "America Pacific."

The maximum length of a time zone string is 130 bytes.

number_of_rules

The number of rules related to this time zone string.

A maximum of 6 rules is allowed for each time zone string.

TZRules

An array where each DSTRules element describes a rule. These rules are used to calculate the time zone displacement for the time zone string.

The definition of the DSTRules structure is:

typedef struct DSTRules
{
    startendDSTInfo  startDST;
    startendDSTInfo  endDST;
    yearDisplInfo    validyrs;
} DSTRules;

Standardtzdispl_hour

The standard time zone displacement hour.

Standardtzdispl_minute

The standard time zone displacement minute.

startDST

Specifies the date and time when daylight saving time (DST) starts. You can specify the fields in the following table. If a field is not applicable, enter 0.

endDST

Specifies the date and time when daylight saving time ends. You can specify the fields in the following table. If a field is not applicable, enter 0.

validyrs

Specifies the years in which the DST start and end dates apply. The following are included in this year range:

Item	Description
start_year	Year when these DST rules start.
end_year	Year when these DST rules end.
Standardtzdispl_hour	Standard time zone displacement hour.
Standardtzdispl_minute	Standard time zone displacement minute.
DSTtzdispl_hour	Time zone displacement hour for daylight saving time.
DSTtzdispl_minute	Time zone displacement minute for daylight saving time.

You can specify the following for startDST and endDST. Enter zero if a field is not applicable.