AnsweredAssumed Answered

How to store UTC dates from within SQL

Question asked by EdwinVriethoff on Oct 5, 2017
Latest reply on Oct 6, 2017 by Kenji Hashimoto

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.

Outcomes