Basically PI Data Archive use localhost.tz and summer time is automatically handled. PI Data Archive keep events as UTC timestamp.
I am not sure why your insert into query shows time difference. Do the other client tool works fine? Does only linked SQL Server get the time difference?
Anyway, I tried to get UTC time from linked SQL Server. (I am not expert of Microsoft SQL Server though) Declare @tzoffset as int; Declare @gettime as Datetime; select @tzoffset = (select datediff(hour,getdate(),getutcdate())); Select @gettime = (Select * FROM OPENQUERY(PIDA,'SELECT time FROM [piarchive]..[pisnapshot] WHERE tag = ''cdt158''')); Select DATEADD(hh,@tzoffset,@gettime)
It can show the snapshot event timestamp as UTC time.
Maybe you can insert it to the PI with converting it to the local time again.