Setting MySQL session time zone

If you want to change the MySQL time zone setting for your MySQL session, you should execute the following SQL query right after the MySQL connection has been established in your scripts:

SET time_zone = 'custom_timezone';

Make sure that you replace custom_timezone with the name of the desired time zone. A list of the valid time zones is available in the zone.tab file. Please refer to the MySQL Server Time Zone Support article of the official MySQL documentation for additional information.


	Online Manual » MySQL » Setting MySQL session time zone Setting MySQL session time zone If you want to change the MySQL time zone setting for your MySQL session, you should execute the following SQL query right after the MySQL connection has been established in your scripts: SET time_zone = 'custom_timezone'; Make sure that you replace custom_timezone with the name of the desired time zone. A list of the valid time zones is available in the zone.tab file. Please refer to the MySQL Server Time Zone Support article of the official MySQL documentation for additional information.