Not only that but in T-SQL, `AT TIME ZONE` takes DST into account but not in the names. So something like:

    SELECT CreatedDate AT TIME ZONE 'UTC' AT TIME ZONE 'Eastern Standard Time' FROM MyTable

would in fact return `CreatedDate` at Eastern Daylight Time if executed today.