TZ_DST Structure - Analytics Database - Teradata Vantage

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 information related to this year range is included:

• start_year - the year when these DST rules start.
• end_year - the year when these DST rules end.
• Standardtzdispl_hour - the standard time zone displacement hour.
• Standardtzdispl_minute - the standard time zone displacement minute.
• DSTtzdispl_hour - the time zone displacement hour for daylight saving time.
• DSTtzdispl_minute -the 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.