17.10 - System TimeZone Hour - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Configuration
Publication ID
B035-1102-171K
Language
English (United States)

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.

If the CURRENT_TIME or CURRENT_TIMESTAMP built-in functions are used in stored procedures, those procedures must be recompiled whenever System TimeZone Hour is changed. Recompilation of stored procedures is not necessary if a time zone string is set using the tdlocaledef utility.

Related Information

For more information on… See…
Built-in time and date functions Teradata Vantage™ - SQL Date and Time Functions and Expressions, B035-1211.
Setting system time zone minute offset System TimeZone Minute
Setting session time zones Information about SET TIME ZONE, CREATE USER, and MODIFY USER in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
Tdlocaledef utility Teradata Locale Definition Utility (tdlocaledef)