I want to change timezone in mysql from EDT to GMT ,
SELECT @@system_time_zone;
+--------------------+
| @@system_time_zone |
+--------------------+
| EDT |
+--------------------+
1 row in set (0.00 sec)
on researching google I am hitting its not possible ! I am pretty sure it should be.
For the current session, just:
SET @@session.time_zone='+00:00'; -- UTC
Or:
SET time_zone = '+00:00';
To make it permanent, you can change mysqld conf file (requires a server restart):
default_time_zone='+00:00'
SELECT @@global.time_zone, @@session.time_zone;
@@global.time_zone | @@session.time_zone :----------------- | :------------------ SYSTEM | SYSTEM
SET @@session.time_zone='+00:00';
SELECT @@global.time_zone, @@session.time_zone;
@@global.time_zone | @@session.time_zone :----------------- | :------------------ SYSTEM | +00:00
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments