我想在nodejs中创建restful app
服务器:centos 7 64x数据库:postgresql附加:express,sequelize表:datetime with timezone
当我从数据库中选择sequelize的行时,created_at列给了我错误的时间 . 5小时添加到日期时间 .
我将centos的时区配置更改为5(Tashkent / Asia)同时将postgresql时区配置更改为5 Datetime在显示时在数据库中是正确的 .
但是当我选择它时会转换成这样的
“createdAt”:“2018-08-12T17:57:20.508Z”
在数据库列中显示此信息
2018-08-12 22:57:20.508 05
config.json
"development": {
"username": "postgres",
"password": "postgres",
"database": "zablet",
"host": "127.0.0.1",
"dialect": "postgres",
"timezone": "Tashkent/Ashgabat",
"define": {
"charset": "utf8",
"dialectOptions": {
"collate": "utf8_general_ci"
},
"freezeTableName": true
}
}
index.js
'use strict';
var fs = require('fs');
var path = require('path');
var Sequelize = require('sequelize');
var basename = path.basename(__filename);
var env = process.env.NODE_ENV || 'development';
var config = require('../config/config.json')[env];
var db = {};
if (config.use_env_variable) {
var sequelize = new Sequelize(process.env[config.use_env_variable], config);
} else {
var sequelize = new Sequelize(config.database, config.username, config.password, config);
}
fs
.readdirSync(__dirname)
.filter(file => {
return (file.indexOf('.') !== 0) && (file !== basename) && (file.slice(-3) === '.js');
})
.forEach(file => {
var model = sequelize['import'](path.join(__dirname, file));
db[model.name] = model;
});
Object.keys(db).forEach(modelName => {
if (db[modelName].associate) {
db[modelName].associate(db);
}
});
db.sequelize = sequelize;
db.Sequelize = Sequelize;
module.exports = db;
更新了config.json
{
"development": {
"username": "postgres",
"password": "postgres",
"database": "postgres",
"host": "127.0.0.1",
"dialect": "postgres",
"define": {
"charset": "utf8",
"dialectOptions": {
"collate": "utf8_general_ci"
},
"freezeTableName": true
},
"dialectOptions": {
"useUTC": false
},
"timezone": "+05:00"
}
}
如何以正确的时区格式从数据库中选择行?
1 回答
这是因为您只设置时区来写入数据库,而不是用于读取 . 这工作正常 . 我正在使用这个 .