A Simple Explanation of Postgres' Timestamp with Time Zone
October 10, 2024
Postgres provides two ways to store a timestamp: TIMESTAMP
and TIMESTAMP WITH TIME ZONE
(or timestamptz
).
I’ve always recommended using the later, as it alleviates all confusion about time zones. Let’s see why.