Let's assume our database session is set to 'America/New_York'.
Imagine we have a table with both types: postgres timestamp vs timestamptz
SET TIME ZONE 'Europe/London'; SELECT * FROM events; Let's assume our database session is set to
For 95% of applications, TIMESTAMPTZ is the correct choice. Its primary advantage is . SELECT * FROM events