[y2ksw]

Originally Posted by Bulent Tekcan

Who know ? Because time read is wrong, when I edit banner time get wrong and I forgot sometimes correction again. This is bug

It is not a blocking bug. It is an annoyance to which there is no real solution, because there are many server settings and there is no such thing as a "right" setup.

The queries you made in order to find out, are relative to the user account. If you query the system time of your server, you can only rely upon UTC.

# date -u
Fri Sep 30 13:05:50 UTC 2016
# date
Fri Sep 30 15:05:56 CEST 2016

Similarily, the mysql server time relies upon the settings of the server and your timezone settings for that mysql server, which may or may not differ. Thus, a mysql query

SELECT NOW();

may or may not show the current date and time. If you have a 10 hours offset each time you save, then you have probably a largely different UTC time compared to your "user" time.

mysql> SELECT NOW(), UTC_TIMESTAMP();
+---------------------+---------------------+
| NOW()               | UTC_TIMESTAMP()     |
+---------------------+---------------------+
| 2016-09-30 15:11:51 | 2016-09-30 13:11:51 |
+---------------------+---------------------+
1 row in set (0.00 sec)