PostgreSQL timestamp踩坑记录与填坑指南

项目Timezone情况

NodeJS：UTC+08

PostgreSQL：UTC+00

timestampTest.js
const { Client } = require(‘pg’)
const client = new Client()

client.connect()
let sql = “
client.query(sql, (err, res) => {
console.log(err ? err.stack : res.rows[0].datetime)
client.end()
})