Purpose
Defines the System Time Zone Hour offset from Universal Coordinated Time (UTC).
Field Group
General
Valid Range
-12 through 14
Default
0
Changes Take Effect
For new sessions begun after the DBS Control Record has been written. Existing sessions are not affected.
Usage Notes
If a time zone string and rule is defined in an SDF file, and processed using the tdlocaledef utility, that value takes precedence over the setting of System TimeZone Hour.
If the TimeZoneString entry in an SDF file is not used, for locations that observe Daylight Savings Time (DST), the System TimeZone Hour value must be updated to adjust the offset used for system time when DST begins and ends.
Like system time, session time zones defined for individual users (with CREATE USER or MODIFY USER) or set for individual sessions (with SET TIME ZONE) can use time zone strings to ensure that the session time automatically adjusts for DST.
Related Topics
| For more information on… | See… |
|---|---|
| Built-in time and date functions | SQL Functions, Operators, Expressions, and Predicates |
| Setting system time zone minute offset | System TimeZone Minute |
| Setting session time zones | SET TIME ZONE, CREATE USER, MODIFY USER in SQL Data Definition Language |
| Tdlocaledef utility | Teradata Locale Definition Utility (tdlocaledef) |