MySQL Forums
Forum List  »  Newbie

Mysql time different
Posted by: Tadeu Camargo da Silva Tadeu
Date: October 30, 2018 08:11AM

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

Options: ReplyQuote


Subject
Written By
Posted
Mysql time different
October 30, 2018 08:11AM
October 30, 2018 09:07AM


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.