django部署ubuntu数据库MYSQL时区问题

SELECT * FROM mysql.time_zone;
SELECT * FROM mysql.time_zone_name;
mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

  

https://dev.mysql.com/doc/refman/5.5/en/mysql-tzinfo-to-sql.html

https://stackoverflow.com/questions/15017799/how-to-convert-utc-date-to-local-time-zone-in-mysql-select-query

posted on 2017-11-08 17:30  VincentZhu  阅读(369)  评论(0编辑  收藏  举报