SELECT SalesOrderID, OrderDate,
    OrderDate AT TIME ZONE 'Eastern Standard Time' AS OrderDate_TimeZoneEST,
    OrderDate AT TIME ZONE 'Eastern Standard Time'
    AT TIME ZONE 'UTC' AS OrderDate_TimeZoneUTC
FROM Sales.SalesOrderHeader;