Sample Header Ad - 728x90

UTC time showing wrong

0 votes
2 answers
527 views
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