17.10 - System TimeZone Minute - 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 Minute offset from Universal Coordinated Time (UTC).

Field Group

General

Valid Range

-59 through 59

Default

0

Changes Take Effect

After the DBS Control Record has been written. Existing sessions are not affected.

Usage Notes

If the CURRENT_TIME or CURRENT_TIMESTAMP built-in functions are used in stored procedures, those procedures must be recompiled whenever System TimeZone Minute 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 Functions, Expressions, and Predicates, B035-1145.
Setting system time zone hour offset System TimeZone Hour
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)