mysql中查询显示为"2020-01-31 20:07:39"
node.js中导出后返回的是格林威治时间,“2014-11-11T00:00:00.000Z”
解决方案:
需要修改以下 sql 配置:
timezone:"SYSTEM"
可合并如下:
var connection = mysql.createConnection({
host: 'localhost',
user: 'root',
password: '5f615edbf51103c2',
database: 'piyanuo_cn',
multipleStatements: true,
timezone:"SYSTEM"
});