Set mysql timezone at runtime via PHP

To set the timezone of mysql at runtime via php use the following code :

$c = mysqli_connect($host, $username, $password);
mysqli_query($c , "SET `time_zone` = '".date('P')."'");

This can be executed when the connection is established and it will set the timezone of mysql to whatever timezone php is set to. Fast and effective.

Last Updated On : 19th October 2011

Subscribe to get updates delivered to your inbox

Leave a comment