search

brianc / node-postgres

PostgreSQL client for node.js.
https://node-postgres.com
MIT License
12.32k stars 1.23k forks source link

Time zone #2417

Open Faizanamin opened 3 years ago

Faizanamin commented 3 years ago

Hello, I m using version ^6.1.0 of this library . the issue I'm facing is that I m getting the wrong time and time zone. locallyI have set my timezone to UTC but while executing the query from postgresql.query({]) function return { TimeZone: 'US/Pacific' } time zone .. any solution to how I set the timezone from your library.

Note: I have set the PostgreSQL time zone to UTC from its command line

kapouer commented 3 years ago

https://node-postgres.com/features/types -> process.env.TZ