15.00 - System TimeZone Hour - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
15.00
Content Type
Configuration
Publication ID
B035-1102-015K
Language
English (United States)
Last Update
2018-09-25

System TimeZone Hour

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.

Note: 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 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” on page 454.

Setting session time zones

SET TIME ZONE, CREATE USER, MODIFY USER in SQL Data Definition Language.

Tdlocaledef utility

Teradata Locale Definition Utility (tdlocaledef).