Alarm_events report in date format

is there a way to display the eventtime on the alarm_events database as a Date?

Thats epoch time in milliseconds, depending on your flavor of database there are various ways to convert it to a date time. MySql for example you can use FROM_UNIXTIME()

1 Like

Currently I am using the default alarm_events database, already try with datetime() and FROM_UNIXTIME() but I can’t make it work.

SQLite doesn’t have any date or time types:

You can use e.g. strftime to round the epoch milliseconds value Ignition stores for display as a string:

You will have to round down to Unix seconds (divide by 1000) for the SQLite functions to work/return useful data.