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:
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