MYSQL data time conversion with datetime Offset in MSSQL Server

 The following will update the date time to your servers system date time adjusted with correct time offset.

Select 

 CONVERT(datetime, 

               SWITCHOFFSET(CONVERT(datetimeoffset, 

                                   MYSQLDateField), 

                            DATENAME(TzOffset, SYSDATETIMEOFFSET()))) as UpdatedDate

from YourMYSQLtable;