Let's face it, most of us store dates in UTC and rely on the front end application to handle local time. Now you've been asked to produce a report across customers in different time zones. Starting SQL 2016, Microsoft introduced the option AT TIME ZONE, which produces a Date Time Offset return. A Date Time … Continue reading UTC to Timezone using At Time Zone option.