Mysql time different
Hello everyone,
We are using "5.7.22-enterprise-commercial-advanced-log" on Linux.
The system date of server is different from MySQL.
- MySQL:
11:05 (none)> show variables like '%zone%';
+------------------+--------+
| Variable_name | Value |
+------------------+--------+
| system_time_zone | -03 |
| time_zone | SYSTEM |
+------------------+--------+
11:04 (none)> SELECT @@GLOBAL.time_zone, @@SESSION.time_zone, now();
+--------------------+---------------------+---------------------+
| @@GLOBAL.time_zone | @@SESSION.time_zone | now() |
+--------------------+---------------------+---------------------+
| SYSTEM | SYSTEM | 2018-10-30 12:05:59 |
+--------------------+---------------------+---------------------+
This is wrong time.
- But the system date server is different (this is OK):
dzsh usr2020 $ date
Tue Oct 30 11:06:45 -03 2018
Can everyone help to fix that issue? Why is time different?
Thank you very much!
Tadeu
Subject
Written By
Posted
Mysql time different
October 30, 2018 08:11AM
November 01, 2018 08:39AM
Sorry, you can't reply to this topic. It has been closed.
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.