Skip to content

Instantly share code, notes, and snippets.

@justinkelly
Created March 10, 2017 01:54
Show Gist options
  • Save justinkelly/2dbd8fefaacf091b01645d8c00cb4d4b to your computer and use it in GitHub Desktop.
Save justinkelly/2dbd8fefaacf091b01645d8c00cb4d4b to your computer and use it in GitHub Desktop.
Equella date format log
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