Postgres Timestamp Vs Timestamptz Now

| Column | What PostgreSQL stores internally | |--------|----------------------------------| | ts_native | 2025-04-14 14:00:00 (exact text, no zone info) | | ts_tz | A UTC timestamp: 2025-04-14 18:00:00+00 (because 2pm ET = 6pm UTC) |

-- Create a test table CREATE TABLE time_test ( ts_native TIMESTAMP, -- without tz ts_tz TIMESTAMPTZ -- with tz ); postgres timestamp vs timestamptz

Use timestamp when the time zone simply doesn't matter or shouldn't change. | Column | What PostgreSQL stores internally |

There are only a few valid use cases for TIMESTAMP WITHOUT TIME ZONE : SELECT * FROM events

SET TIME ZONE 'Europe/London'; SELECT * FROM events;

The difference is not in ; it is in presentation and input handling .