Time Zone Engine Variables

system_time_zone variable

This variable stores the time zone set on the host (the Linux OS). It is a read-only variable and read by the engine during startup.

SELECT @@SYSTEM_TIME_ZONE;
+--------------------+
| @@SYSTEM_TIME_ZONE |
+--------------------+
| UTC                |
+--------------------+

time_zone variable

This variable exists in SingleStore only to conform to MySQL standards. Setting this variable does not do anything. If SingleStore is using the time zone setting of the host (the Linux OS), then the time_zone variable returns the value SYSTEM. If you set the time zone through SingleStore, via the default_time_zone configuration option, then the time_zone variable returns the value of default_time_zone.

SELECT @@TIME_ZONE;
+-------------+
| @@TIME_ZONE |
+-------------+
| SYSTEM      |
+-------------+

Last modified: June 22, 2022

Was this article helpful?