The following table describes the TIME ZONE options in detail.
|LOCAL||Changes the value for the local time zone displacement to that defined for the system default.
Note that this is a persistent setting. If the system-defined default time zone should change, the value defined for the user remains at the value defined for it when the user was created. To change the value, you must submit a new MODIFY USER request.
|NULL||No default TIME ZONE displacement is defined for the user.|
|± ‘quotestring’||An optionally signed value that sets a non-system-default interval offset for converting the user TIME ZONE displacement.
The format is hh:mm.
|‘time_zone_string’||Changes the value of the default time zone for the user to the displacement specified by ‘time_zone_string’.
If you specify an explicit non-GMT time zone string, it is passed to a system-defined UDF named GetTimeZoneDisplacement that interprets the string and determines the appropriate time zone displacement for the session (see Teradata Vantage™ SQL Date and Time Functions and Expressions, B035-1211 for information about this system-defined UDF). Time zone strings that are expressed in terms of GMT do not enable automatic adjustments for Daylight Saving Time. Regions that do not follow Daylight Saving Time are only represented by GMT values.
The valid time zone strings are listed in the following table.
The following table lists the valid time zone strings for the ‘time_zone_string’ option.
|Valid Time Zone Strings|