AT TIME ZONE selects earlier offset during ambiguous DST fall-back without disambiguation option
SQL Server's AT TIME ZONE function converts naive datetime or datetimeoffset values to a target Windows time zone using the host OS's time zone database. During the fall-back daylight saving transition, a local clock time such as 2023-11-05 01:30 occurs twice—once in daylight time (UTC-4) and once in standard time (UTC-5). The function deterministically retu