Available values in mainland China: Asia/Chongqing, Asia/Shanghai, Asia/Urumqi (in the order of Chongqing, Shanghai, and Urumqi)
Available in Hong Kong and Taiwan regions: Asia/Macao, Asia/Hong_Kong, Asia/Taipei (in the order of Macao, Hong Kong, and Taipei)
Singapore: Asia/Singapore
Other available values are: Etc/GMT-8, Singapore, Hongkong, PRC
1. Set the time zone in Linux. Take CentOS5.5 as an example:
The code is as follows: |
Copy code |
Cp-f/usr/share/zoneinfo/Asia/Shanghai/etc/localtime |
2. Set the time zone in MySQL
Edit the MySQL configuration file: my. cnf/my. ini, and add:
The code is as follows: |
Copy code |
Default-time-zone = '+ 8:00' |
In fact, if the OS time zone of MySQL is set correctly, you do not need to set the time zone in MySQL because the OS time zone is automatically used when the MySQL service is started.
3. Set the time zone in PHP
In the PHP configuration file PHP. ini:
The code is as follows: |
Copy code |
Date. timezone = "Asia/Shanghai" |
After setting, you are advised to restart the system.
If you have purchased a Web space, you are not authorized to configure the time zone in Linux PHP MySQL. In this case, you only need to set the time zone corresponding to the OS in the PHP script, because MySQL uses the OS time zone by default. If the OS time zone is 'Asia/Shanghai', use one of the following two statements:
The code is as follows: |
Copy code |
Ini_set ('date. timezone ', 'Asia/Shanghai '); Date_default_timezone_set ('Asia/Shanghai '); |
2. In windows, we need to set the time zone in PHP. INI.
The code is as follows: |
Copy code |
Date. timezone = PRC |
Set the time zone in the code
The code is as follows: |
Copy code |
1 date_default_timezone_set ('Asia/Shanghai'); // 'Asia/Shanghai' Asia/Shanghai 2 date_default_timezone_set ('Asia/Chongqing '); // The value of Asia/Chongqing is "Asia/Chongqing" 3 date_default_timezone_set ('prc'); // PRC is "People's Republic of China" 4i ni_set ('date. timezone ', 'etc/GMT-8 '); 5 ini_set ('date. timezone ', 'prc '); 6 ini_set ('date. timezone ', 'Asia/Shanghai '); 7 ini_set ('date. timezone ', 'Asia/Chongqing '); |
Any of the above seven methods can meet our needs.
When the system is initialized, add
The code is as follows: |
Copy code |
Ini_set ('date. timezone ', 'Asia/Shanghai '); Or Date_default_timezone_set ("PRC "); |
The time zone difference is 8.