pgx icon indicating copy to clipboard operation
pgx copied to clipboard

Timestamps round trip incorrectly on non UTC systems

Open wbl opened this issue 2 years ago • 21 comments

When I am on a system not set to UTC, and store a timestamp to a database via the database/sql compatible interface, the value in the database is stored with the same numeric value but the zone set to UTC. When reading back the timestamp stored in the DB is correctly reconstituted, but alas this is not the same as the value that went in.

wbl avatar Apr 26 '22 19:04 wbl