Time Zone Engine Variables
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
system_ time_ zone
variable
This variable stores the time zone set on the host (the Linux OS).
SELECT @@SYSTEM_TIME_ZONE;
+--------------------+
| @@SYSTEM_TIME_ZONE |
+--------------------+
| UTC |
+--------------------+
time_ zone
variable
This variable exists in SingleStore only to conform to MySQL standards.time_
variable returns the value SYSTEM
.time_
variable returns the value of default_
.
SELECT @@TIME_ZONE;
+-------------+
| @@TIME_ZONE |
+-------------+
| SYSTEM |
+-------------+
Last modified: June 22, 2022