Alarm_events report in date format

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

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:
https://www.sqlite.org/datatype3.html

You can use e.g. strftime to round the epoch milliseconds value Ignition stores for display as a string:
https://www.sqlite.org/lang_datefunc.html

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

2 Likes