system_time_zone

Overview

In 23.08 ES, 23.07 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 23.08 ES, 23.07 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 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)

PRIVILEGES

EXAMPLES

ERROR HANDLING

FEATURE INTERACTION

RESPONSES

DIAGNOSIS

ISO 9075:2016

CHANGE HISTORY

Release Series

History

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

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

23.08 Enterprise

  • Present starting in MariaDB Enterprise Server 23.08.0.

23.07 Enterprise

  • Present starting in MariaDB Enterprise Server 23.07.0.

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