Alarm & Event Timestamp Timezones

Ignition
1

I am working on collecting data from user’s alarm (alarm_events) and activity (audit_events) tables from a MSSQL database. In both cases (at least for the Ignition sample project), those columns are simply DateTime.

  1. It looks like those values are in the local timezone of the Gateway server. (Not the DB server) Is this correct?
  2. Can those column datatypes be changed to DateTimeOffset for instance? Would Ignition work that way / would it record the timezone info correctly?
  3. What is the best-practice/typical approach seen in production systems?
  4. What are the various ways you guys have seen it handled?

Thanks!

2

You should convert to datetime2. That should work naturally.