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 Information
| For more information on… | See… |
|---|---|
| built-in time and date functions | 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 SQL Data Definition Language Syntax and Examples, B035-1144. |
| Tdlocaledef utility | Teradata Locale Definition Utility (tdlocaledef) |