Use timestamptz, not timestamp, for points in time

Use timestamptz, not timestamp, for points in time | BeforeMerge Rules | BeforeMerge

Why this matters

timestamp (without time zone) stores wall-clock values with no offset, so the same row means different absolute instants depending on the session's TimeZone. timestamptz normalizes to UTC on write and renders in the session zone on read, keeping points in time unambiguous.

-- bad
created_at timestamp NOT NULL DEFAULT now();
 
-- good
created_at timestamptz NOT NULL DEFAULT now();

Why This Matters

Related Rules

Catch this automatically on every PR

Why this matters