# Alarm\_events report in date format

**URL:** <https://forum.inductiveautomation.com/t/alarm-events-report-in-date-format/56922>\
**Category:** Ignition\
**Tags:** ignition80, scripting, database\
**Created:** [March 7, 2022, 6:36pm UTC](https://forum.inductiveautomation.com/t/alarm-events-report-in-date-format/56922 "2022-03-07T18:36:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ivan\_Habib\_Sierra\_Fe](https://avatars.discourse-cdn.com/v4/letter/i/22d042/32.png) [@Ivan\_Habib\_Sierra\_Fe](https://forum.inductiveautomation.com/u/Ivan_Habib_Sierra_Fe)\
**Post date:** [March 7, 2022, 6:36pm UTC](https://forum.inductiveautomation.com/t/alarm-events-report-in-date-format/56922/1 "2022-03-07T18:36:23Z")

</div>

is there a way to display the eventtime on the alarm\_events database as a Date?  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/f/7f1f49aa3fe2bbb5b1d06e7fc045ab5a56f68636.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/d/6d84c87baa8a39d2e776da6f9034149ade20ef38.png)

---

<div class="post-metadata">

**Author:** ![josborn](https://avatars.discourse-cdn.com/v4/letter/j/4bbf92/32.png) [@josborn](https://forum.inductiveautomation.com/u/josborn)\
**Post date:** [March 7, 2022, 6:46pm UTC](https://forum.inductiveautomation.com/t/alarm-events-report-in-date-format/56922/2 "2022-03-07T18:46:17Z")

</div>

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()`

---

<div class="post-metadata">

**Author:** ![Ivan\_Habib\_Sierra\_Fe](https://avatars.discourse-cdn.com/v4/letter/i/22d042/32.png) [@Ivan\_Habib\_Sierra\_Fe](https://forum.inductiveautomation.com/u/Ivan_Habib_Sierra_Fe)\
**Post date:** [March 7, 2022, 7:04pm UTC](https://forum.inductiveautomation.com/t/alarm-events-report-in-date-format/56922/3 "2022-03-07T19:04:00Z")

</div>

Currently I am using the default alarm\_events database, already try with datetime() and FROM\_UNIXTIME() but I can’t make it work.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/1/01f4371df4f3748ac31f6afa460fff99601963a9.png)

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [March 7, 2022, 7:18pm UTC](https://forum.inductiveautomation.com/t/alarm-events-report-in-date-format/56922/4 "2022-03-07T19:18:05Z")

</div>

SQLite doesn’t have any date or time types:  
[https://www.sqlite.org/datatype3.html](https://www.sqlite.org/datatype3.html)

You can use e.g. `strftime` to round the epoch **milli** seconds value Ignition stores for display as a string:  
[https://www.sqlite.org/lang\_datefunc.html](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.