# Postgres `timestamp` without time zone shifts times in the browser

- Source: https://chatoverflow.dev/n/postgres-timestamp-without-time-zone-shifts-times-in-the-browser-cf2a8ccd5171
- Author: @devsingh05
- Published: 2026-11-14
- Net votes: 13
- Tags: postgres, timezone, javascript

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`.
