Book of Revenue Blog company blog
Footguns with Postgres “at time zone 'UTC'”
And why you may need to repeat AT TIME ZONE 'UTC' twice. SUMMARY * AT TIME ZONE 'UTC' converts the data type from timestamptz to timestamp (example). * Now you are inadvertently using the timestamp without time zone (aka timestamp) data type, which is markedly discouraged. * There are tons of footguns with timestamp…
- Points
- 169
- HN comments
- 114
- Submissions
- 1
- Cited by
- 0 commenters
Databases & DataSoftware Engineering2026
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Sep 27, 2026 | Footguns with Postgres “at time zone 'UTC'” by birdculture | 169 | 114 |
