adam.doherty at esso.ca
Fri Jun 22 18:49:39 CEST 2018
I'm trying to figure how to calculate the time delta between two events.
My events have a timestamp, event source, event type, and an event state and event id.
So an event looks like -
event_date_time event_source event_type event_state event_id
2018-06-22 09:05:07.000000 MODULE123 TYPEABC ACK 24567890
2018-06-22 11:32:14.000000 MODULE123 TYPEABC UNACK 24812266
This makes up a unique "event", start to finish.
However I have hundreds or thousands of entries between and I want be able to group them together in their unique pairings as above.
I'm not sure how to wrap my head around this one.
More information about the users-list