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
USAGE
DETAILS
- SYNONYMS
- SCHEMA
- PARAMETERS
- SKYSQL
- PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
RELATED TOPICS
EXTERNAL REFERENCES

Overview

In 11.4 ES, 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 11.4 ES, 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_time_zone.

USAGE

SkySQL interfaces refer to the system_time_zone system variable as default_time_zone. The system variable can be configured in Configuration Manager Configuration 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
11.4 Enterprise	Present starting in MariaDB Enterprise Server 11.4.3-1.
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.6 Community	Present starting in MariaDB Community Server 10.6.0.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.5 Community	Present starting in MariaDB Community Server 10.5.0.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.
10.4 Community	Present starting in MariaDB Community Server 10.4.0.
10.3 Enterprise	Present starting in MariaDB Enterprise Server 10.3.16-1.
10.3 Community	Present starting in MariaDB Community Server 10.3.0.
10.2 Enterprise	Present starting in MariaDB Enterprise Server 10.2.25-1.
10.2 Community	Present starting in MariaDB Community Server 10.2.0.

Release Series	History
11.4 Enterprise	Present starting in MariaDB Enterprise Server 11.4.3-1.
10.6 Enterprise	Present starting in MariaDB Enterprise Server 10.6.4-1.
10.5 Enterprise	Present starting in MariaDB Enterprise Server 10.5.3-1.
10.4 Enterprise	Present starting in MariaDB Enterprise Server 10.4.6-1.

EXTERNAL REFERENCES

Additional information on this topic may be found in the MariaDB Public Knowledge Base.