To set Time zone in GMT set time_zone is used with specified time_zone value
|
1 |
SET time_zone='+00:00'; |
To check our change reflated on database use following query
|
1 |
SELECT @@global.time_zone, @@session.time_zone; |
|
1 2 3 4 5 6 |
+--------------------+---------------------+ | @@global.time_zone | @@session.time_zone | +--------------------+---------------------+ | SYSTEM | +00:00 | +--------------------+---------------------+ 1 row in set (0.00 sec) |