Timezone
\n[root@server02 ~]# date \u2028Fri Feb 24 02:11:38 CST 2012
\nMySQL time-zone:
\nmysql> show global variables like ‘%time_zone%’;
\n\u2028+——————+——–+
\n\u2028| Variable_name | Value |
\n\u2028+——————+——–+ \u2028
\n| system_time_zone | CST |
\n\u2028| time_zone | SYSTEM |
\n\u2028+——————+——–+
\n\u20282 rows in set (0.00 sec)<\/p>\n
mysql> show variables like ‘%time_zone%’;
\n\u2028+——————+——–+
\n\u2028| Variable_name | Value |
\n\u2028+——————+——–+
\n\u2028| system_time_zone | CST |
\n\u2028| time_zone | SYSTEM |
\n\u2028+——————+——–+
\n\u20282 rows in set (0.00 sec)<\/p>\n
The MySQL timezone is inherited from the server’s timezone.<\/p>\n
PHP timezone is CST (also inherited from the server timezone).<\/p>\n
[root@server02 ~]# php 2>\/dev\/null <\/p>\n
\u2028< ?php \n\u2028echo date_default_timezone_get(); \n\u2028?>
\n\u2028America\/Chicago<\/p>\n","protected":false},"excerpt":{"rendered":"
Timezone [root@server02 ~]# date \u2028Fri Feb 24 02:11:38 CST 2012 MySQL time-zone: mysql> show global variables like ‘%time_zone%’; \u2028+——————+——–+ \u2028| Variable_name | Value | \u2028+——————+——–+ \u2028 | system_time_zone | CST | \u2028| time_zone | SYSTEM | \u2028+——————+——–+ \u20282 rows in … Continue reading