UTC time is showing incorrectly in mysql 5.1. currently, it is 9 AM
mysql> SELECT UTC_TIMESTAMP, UTC_TIMESTAMP( );
+---------------------+---------------------+
| UTC_TIMESTAMP | UTC_TIMESTAMP( ) |
+---------------------+---------------------+
| 2018-08-01 14:15:03 | 2018-08-01 14:15:03 |
+---------------------+---------------------+
1 row in set (0.00 sec)
SELECT current_timestamp dt1, utc_timestamp dt2, @@global.time_zone tz1, @@session.time_zone tz2;
+---------------------+---------------------+--------+--------+
| dt1 | dt2 | tz1 | tz2 |
+---------------------+---------------------+--------+--------+
| 2018-08-01 09:15:56 | 2018-08-01 14:15:56 | SYSTEM | SYSTEM |
+---------------------+---------------------+--------+--------+
1 row in set (0.01 sec)
Please let me know how to fix it.
Asked by Siva
(101 rep)
Aug 1, 2018, 07:58 AM
Last activity: Aug 1, 2018, 11:00 AM
Last activity: Aug 1, 2018, 11:00 AM