Skip to content

Instantly share code, notes, and snippets.

@justinkelly

justinkelly/equella.sql

Created March 10, 2017 01:54
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save justinkelly/2dbd8fefaacf091b01645d8c00cb4d4b to your computer and use it in GitHub Desktop.
Save justinkelly/2dbd8fefaacf091b01645d8c00cb4d4b to your computer and use it in GitHub Desktop.
Download ZIP
Equella date format log
Raw
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;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment