大致总结就2种方法:
1.
const Sequelize = require('sequelize');
const sequelize = new Sequelize('dbname', 'username', 'password', {
host: 'localhost',
dialect: 'mysql',
pool: {
max: 50,
min: 0,
idle: 10000
},
timezone: '+08:00' //东八时区
});
2.
程序中设置process.env.TZ = 'Asia/Shanghai';
const Sequelize = require('sequelize');
const sequelize = new Sequelize('dbname', 'username', 'password', {
host: 'localhost',
dialect: 'mysql',
pool: {
max: 50,
min: 0,
idle: 10000
},
timezone: process.env.TZ
});
之前在做的就是这种,因为设置了环境变量却依旧得不到正确的时间,以为是数据库的问题。后面看到API才知道,需要在sequlize里面引用,否则没用。