我想更新PostgreSQL上的时间戳列:
function updateStatusCreated(request, response, next) {
const date_generation_file = new Date();
pool.query(
`UPDATE data
SET report_status = 'CREATED', date_generation = '${date_generation_file}'`
),
(error, results) => {
if (error) {
return next(error);
}
return response.status(200).json(results);
};
return next();
}
但是我收到这个错误信息:
UnhandledPromiseRejectionWarning: error: syntax error at or near "'Tue Oct 19 2021 14:19:29 GMT+0200 (GMT+02:00)'"
列的参数为timestamp with timezone">
最佳选择是使用Sequelize ORM