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

Teradata Vantage™ - Database Utilities

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Publication ID
English (United States)

Defines the System Time Zone Minute offset from Universal Coordinated Time (UTC).

Field Group


Valid Range

-59 through 59



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)