KB-31412: Converting the Query's E3TimeStamp into UTC/GMT time zone.

Question:

How can I convert a date returned in the Query (E3TimeStamp) into UTC/GMT time zone?

Solution:

To do so, you can use SQL’s DATEADD function.

Example:

SELECT DATEADD(minute, <%TimeZone%>, Alarms.E3TimeStamp) AS UTCTime, Alarms.Area, Alarms.Message
FROM Alarms
ORDER BY Alarms.E3TimeStamp ASC

Thus, the time zone can be set up (in minutes) via SQL’s TimeZone variable.

KB-31412: Converting the Query’s E3TimeStamp into UTC/GMT time zone.