MySQL - Daylight Savings Time
For some reason when daylig开发者_运维百科ht savings time kicked in, one of my websites that auto-publishes at 12:00 midnight starting publishing at 11:00pm. Is there any way to set a MySQL server variable to just handle the daylight savings time change correctly?
Please provide ...
- the output from
SHOW VARIABLES LIKE '%zone';
- the Operating System's understanding of time
- whether the timezone tables were installed for mysql -- see "Populating the timezone tables" in http://dev.mysql.com/doc/refman/5.6/en/time-zone-support.html
- which timezone is giving you trouble. (There are dozens, maybe hundreds, of changes every year, somewhere in the world.)
精彩评论