system_time_zone
This page is part of MariaDB's Documentation.
The parent of this page is: System Variables for MariaDB Enterprise Server
Topics on this page:
Overview
In 10.6 ES, 10.6 CS, 10.5 ES, 10.5 CS, 10.4 ES, 10.4 CS, 10.3 ES, 10.3 CS, 10.2 ES, 10.2 CS:
Sets the server's system time zone.
In 10.6 ES, 10.5 ES, 10.4 ES:
Sets the server's system time zone. SkySQL interfaces refer to this system variable as
default_time_zone.
The SkySQL interfaces refer to this variable as default_
See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, in 10.4 ES, in 10.3 ES, in 10.2 ES, in 10.6 CS, in 10.5 CS, in 10.4 CS, in 10.3 CS, and in 10.2 CS
See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES
USAGE
SkySQL interfaces refer to the system_time_zone system variable as default_time_zone. The system variable can be configured in Configuration ManagerConfiguration Manager for some topologies using that name.
The system_time_zone system variable can be set indirectly by setting the default_time_zone option in a configuration file:
[mariadb]
default_time_zone='UTC'
The global value of the system_time_zone system variable can also be set dynamically at runtime by executing SET GLOBAL:
SET GLOBAL system_time_zone='UTC'
When the system_time_zone system variable is set dynamically at runtime, its value will be reset the next time the server restarts. To make the value persist on restart, set the default_time_zone option in a configuration file too.
DETAILS
SYNONYMS
SCHEMA
PARAMETERS
Command-line | Not Supported |
Configuration file | Not Supported |
Dynamic | No |
Scope | Global |
Data Type | VARCHAR |
Product Default Value | NULL |
SKYSQL
Cloud | SkySQL Topology | ES Ver | Service Default |
|---|---|---|---|
AWS | Multi-Node Analytics | 10.6 | UTC (choices: a valid IANA time zone value) |
Single Node Analytics | 10.6 | UTC (choices: a valid IANA time zone value) | |
Replicated Transactions | 10.4 | UTC (choices: a valid IANA time zone value) | |
10.5 | UTC (choices: a valid IANA time zone value) | ||
10.6 | UTC (choices: a valid IANA time zone value) | ||
Single Node Transactions | 10.4 | UTC (choices: a valid IANA time zone value) | |
10.5 | UTC (choices: a valid IANA time zone value) | ||
10.6 | UTC (choices: a valid IANA time zone value) | ||
GCP | Multi-Node Analytics | 10.6 | UTC (choices: a valid IANA time zone value) |
Single Node Analytics | 10.6 | UTC (choices: a valid IANA time zone value) | |
Replicated Transactions | 10.4 | UTC (choices: a valid IANA time zone value) | |
10.5 | UTC (choices: a valid IANA time zone value) | ||
10.6 | UTC (choices: a valid IANA time zone value) | ||
Single Node Transactions | 10.4 | UTC (choices: a valid IANA time zone value) | |
10.5 | UTC (choices: a valid IANA time zone value) | ||
10.6 | UTC (choices: a valid IANA time zone value) |
Cloud | SkySQL Topology | ES Ver | Service Default |
|---|---|---|---|
AWS | ColumnStore Data Warehouse | 10.6 | UTC (a valid time zone name) |
Enterprise Server With Replica(s) | 10.4 | UTC (a valid time zone name) | |
10.5 | UTC (a valid time zone name) | ||
10.6 | UTC (a valid time zone name) | ||
Enterprise Server Single Node | 10.4 | UTC (a valid time zone name) | |
10.5 | UTC (a valid time zone name) | ||
10.6 | UTC (a valid time zone name) | ||
GCP | ColumnStore Data Warehouse | 10.6 | UTC (a valid time zone name) |
Enterprise Server With Replica(s) | 10.4 | UTC (a valid time zone name) | |
10.5 | UTC (a valid time zone name) | ||
10.6 | UTC (a valid time zone name) | ||
Enterprise Server Single Node | 10.4 | UTC (a valid time zone name) | |
10.5 | UTC (a valid time zone name) | ||
10.6 | UTC (a valid time zone name) |
See SkySQL details in MariaDB SkySQL previous release
See SkySQL details in MariaDB SkySQL new release
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
|---|---|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
|---|---|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
RELATED TOPICS
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.