Convert UNIX timestamp (epoch time) to date/time in an Analysis

In case the issue of then using the date in something like Excel, you can format it to your preferred regional format, and can even leverage the great tip @brolly33 shared recently in A new relevance tidbit: Date with dash.

Q: (((concatenation "-" of (day_of_month of it as two digits as string;month of it as two digits as string;year of it as string) of date (local time zone) of it) & " " & (concatenation ":" of ((two digit hour of it);(two digit minute of it);(two digit second of it)) of time (local time zone) of it)) of ((column "IssuedTime" of it as string as integer) * second + "01 Jan 1970 00:00:00 -0000" as local time)) of rows of statements ("SELECT IssuedTime,ActionName, IssuerName, ActionID FROM ACTION_HISTORY") of sqlite databases of files "ActionHistory.db" of folders "__Global" of data folders of client
A: 29-11-2016 14:59:17
A: 20-03-2018 13:38:50
A: 29-03-2018 10:09:43
A: 26-08-2019 11:27:25
1 Like