Postgres Timestamp Vs Timestamptz [top] (Trusted · CHOICE)

To preserve the user's original time zone (e.g., for compliance or display), you need a :

If your column is TIMESTAMPTZ , but your application sends a naive timestamp, PostgreSQL will assume the timestamp is in your session's time zone. If your server is in UTC and your user is in Sydney – . postgres timestamp vs timestamptz

If you care when something happened, use TIMESTAMPTZ . Your future self (and your global users) will thank you. Have a horror story about timestamps gone wrong? Share it in the comments below! To preserve the user's original time zone (e

Now, what is stored?