时间存储问题
mysql保存时会自动保存为UTC格式,可以在config中配置:
exports.sequelize = {
dialect: 'mysql',
....
timezone: '+08:00' // 保存为本地时区
}
但是egg-sequelize在读取时间时,还是会返回UTC格式,还需要改一下配置,添加:
exports.sequelize = {
dialect: 'mysql',
....
timezone: '+08:00' ,// 保存为本地时区
dialectOptions: {
dateStrings: true,
typeCast(field, next) {
// for reading from database
if (field.type === "DATETIME") {
return field.string();
}
return next();
}
}
}