Report Time Stamp display in minutes and second

Priyanka.Khandge · March 24, 2021, 6:20am

Hello guys,

I trying to create a report using an alarm journal query but event time only displays the date. event time column displays date also time (hr, min, sec).

Any ideas? Why not see the time only display date.

PGriffith · March 24, 2021, 3:41pm

There should be a date format property in the Property Inspector for the table cell.

Priyanka.Khandge · March 25, 2021, 5:20am

Thank you so much @PGriffith for the support. Slove my problem using your solution.

Priyanka.Khandge · March 25, 2021, 1:19pm

@PGriffith I’m facing another problem please give me any ideas.

I trying to create a standard transaction group but t_stamp not showing the proper format.

PGriffith · March 25, 2021, 3:42pm

Are you using a SQLite DB? That looks like a Java or Unix timestamp: https://www.unixtimestamp.com/ (Java timestamps are the count of milliseconds, Unix timestamps are the count of seconds).
Your DB software should be able to coerce that into a date/time in a query, but if it is SQLite then you should be able to ‘automatically’ query it; the SQLite JDBC driver will attempt to coerce long timestamps to dates for you.