System TimeZone Minute - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynh1604715438919.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantage™

Purpose

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 Topics

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 "SET TIME ZONE", "CREATE USER", "MODIFY USER" in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
Tdlocaledef utility Teradata Locale Definition Utility (tdlocaledef)