SingleStore DB

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 DB only to conform to MySQL standards. Setting this variable does not do anything. If SingleStore DB 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 DB, 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      |
+-------------+