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.)
加载中,请稍侯......
精彩评论