MySQL Forums
Forum List  »  General

system_time_zone
Posted by: Benoit St-Jean
Date: May 17, 2023 01:14PM

My server seems to have garbage stored in the system_time_zone variable.

It's currently set at "Est (Heure d'été)' and causes all kinds of problems.

I'm on Windows 10 and using MySql 5.7.11

Documentation says that time variable (@@system_time_zone) is set at server startup and retrieved from the OS (Windows 10 in my case).

Where is this variable set or retrieved on Windows 10?. It's not showing anywhere in the my.ini configuration file nor in any windows system variable!


Other timezone related variables from the server:

mysql> select @@system_time_zone;
+--------------------+
| @@system_time_zone |
+--------------------+
| Est (heure d’été) |
+--------------------+
1 row in set (0.00 sec)

mysql> show variables like '%zone';
+------------------+--------------+
| Variable_name | Value |
+------------------+--------------+
| system_time_zone | Est (heure d |
| time_zone | -05:00 |
+------------------+--------------+
2 rows in set, 1 warning (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
system_time_zone
May 17, 2023 01:14PM
May 17, 2023 06:13PM
May 18, 2023 06:59AM
May 19, 2023 05:01AM
May 18, 2023 07:06AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.