We have connected PI as a linked server in SQL server.
For example, currently our queries look like this:
SELECT * FROM OPENQUERY(PI, 'INSERT INTO piarchive..picomp2 (tag, time, value, annotations) VALUES (''SU1.1051-3.VAL'', ''2017-09-30 00:00'', 22, ''anno'')')
SELECT * FROM OPENQUERY (PI, 'UPDATE piarchive..picomp2 SET annotations = ''anno'', value = 22 WHERE tag = ''SU1.1051-3.VAL'' AND time = ''2017-09-30 00:00''')
The problem is that we have no option to insert the correct times during the wintertime shifting.
Does anyone know how to insert UTC times from within a SQL Server stored procedure?
Thanks for your help.