Convert imported data to dates with time zones

Now that we have seen the three type-safe conversion functions, we can begin to apply them against real data sets. In this scenario, we will parse data from the dbo.ImportedTime table. We used a different application to load data from this table and looked at it in a prior exercise. This time, we will retrieve data for all rows, not just the ones the importing application marked as valid.

Fill in the missing TRY function name inside the EventDates common table expression.
Convert the EventDateOffset column to a date-time offset string, and then a localized date and time.
Convert the EventDateOffset event dates to "UTC".
Convert the EventDateOffset event dates to "US Eastern Standard Time" using AT TIME ZONE.

Take Hint (-30 XP)

Exercise

Convert imported data to dates with time zones

Instructions