How does PostgreSQL's AT TIME ZONE handle daylight saving transitions when converting UTC timestamps to a regional time zone on DigitalOcean Managed Databases?
You need to persist event timestamps in UTC and later present them in a user‑specific regional time zone, accounting for daylight‑saving shifts. Using a DigitalOcean Managed PostgreSQL database, you store the values as timestamptz and plan to convert them with the AT TIME ZONE operator when querying. However, you are unsure how the operator treats the input