Equella date format log

equella.sql

select extract( day from diff ) days,
        extract( hour from diff ) hours,
         extract( minute from diff ) minutes,
         extract( second from diff ) seconds,
         (select Max("timestamp") - Min("timestamp")) diff
from equella.audit_log_entry;