smatdb question Cloverleaf 19.1 convert integer timestamp to human readable form

None of the built in utilities seem to produce a human readable output for a date value. I am trying to do a select statement in a date range to get a count of messages. Any suggestions, please note not an expert on sqllite.

SELECT
datetime (TimeArc,’unixepoch’),
date (TimeArc,’unixepoch’),
time (TimeArc,’unixepoch’)
FROM smat_msgs;