SmartVPS - the complete multi-account hosting solution! Each individual account comes with free backups, addon domains, PHP-FPM with OPcache and server-side caching for lightning-fast sites. And all this at a great price!

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.