WEB HOSTING SUPPORT NETWORK
     
 

Setting MySQL session time zone

If you want to change the MySQL time zone setting for your MySQL session, you could do this with the following SQL query in your scripts:

SET time_zone = 'timezone';

It has to be executed right after the MySQL connection has been established. You should replace the timezone string with the name of the desired time zone. A list of the valid time zones is available in the zone.tab file. Please consult this article of the MySQL documentation for additional information.