The MySQL time zone defaults to the server's time zone. Often encountered in use.
You can view it through the following command
View time zone
SQL code
. mysql> show variables like '%time_zone%'; . +------------------+--------+ . | Variable_name | Value | . +------------------+--------+ . | system_time_zone | CST | . | time_zone | SYSTEM | . +------------------+--------+ . 2 rows in set (0.00 sec)
Explanation: If the value of time_zone is SYSTEM, it means that it The time zone is the same as the time zone value of the operating system.
You can modify the time zone by modifying my.cnf
and adding
default-time-zone=timezone
under [mysqld]. For example:
default-time-zone = ‘+8:00’
Remember to restart msyql after changing it
Be sure to add it under [mysqld], otherwise the error message "unknown variable 'default-time-zone= 8:00'" will appear
In addition, you can also pass the command set time_zone = timezone
For example, Beijing time (GMT 0800)
set time_zone = ‘+8:00’;
>>In the PHP program>>
date_default_timezone_set('PRC') or die('时区设置失败，请联系管理员！');
>>When querying or using the database>>
//Once the database is connected, the code to change the MySQL time follows.
mysql_query("SET time_zone = '+8:00'") or die('时区设置失败，请联系管理员！');
This article explains how to set the MySQL time zone. For more related content, please pay attention to the php Chinese website.
Related recommendations:
How to use database methods to save session
Five ways to prevent SQL injection
The above is the detailed content of How to set MySQL time zone. For more information, please follow other related articles on the PHP Chinese website!