Tag Archives: Timezone

Setting your timezone in mysql

If you want to set your timezone in mysql for your database connection, do this.

SET time_zone = ‘+2:00′;

Keep in mind that the number should be correct and can also have a minus sign, based on the timezone you want to set ofcourse. Do watch out for the UTC timezone, because mysql requires the +.

SET time_zone = ‘+0:00′;

Timezone php.ini setting

date.timezone = “Europe/Brussels”

Make sure this setting is properly configured in your php.ini, since date/time functions may trigger notices otherwise.