15.00 - System TimeZone Minute - 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 Minute

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  

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

Setting session time zones

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

Tdlocaledef utility

Teradata Locale Definition Utility (tdlocaledef).