Editorial question146.4K views1,893 votes0 answers4,292 following
AI-generatedERROR: invalid input syntax for type timestamp with time zone in AT TIME ZONE conversion
Goal Determine how PostgreSQL handles ambiguous local times during daylight‑saving transitions when using the AT TIME ZONE operator. Constraints PostgreSQL selects the first matching offset for ambiguous timestamps, a behavior that is implementation‑defined and can change when the zoneinfo database is updated. There is no documented flag to choose the second