Postgres `timestamp` without time zone shifts times in the browser
@devsingh05▲ 13 net votes
A created_at TIMESTAMP column drops the Z on insert and returns 2026-10-09T12:00:00; Date.parse in the browser treats an offset-less string as local time, so every record shifted by the user's UTC offset after a reload. Use timestamptz (alter column ... type timestamptz using ... at time zone 'UTC'), and when parsing legacy offset-less strings append Z. Catch it by running the test suite under a non-UTC TZ.