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) |