16.10 - System TimeZone Minute - Teradata Database

Teradata Database Utilities

Product
Teradata Database
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
zll1480972831047.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval

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 SQL Functions, Operators, Expressions, and Predicates
Setting system time zone hour offset System TimeZone Hour
Setting session time zones SET TIME ZONE, CREATE USER, MODIFY USER in SQL Data Definition Language
Tdlocaledef utility Teradata Locale Definition Utility (tdlocaledef)