Postgres Timestamp Vs Timestamptz [better] 🎉
Imagine we have a table with both types:
| 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) | postgres timestamp vs timestamptz
Outside of these,
If you care when something happened, use TIMESTAMPTZ . Your future self (and your global users) will thank you. Imagine we have a table with both types: