martin.kersten at cwi.nl
Sat Jun 23 14:24:01 CEST 2018
Consider a self join to start with.
On 22/06/2018 18:49, Doherty, Adam wrote:
> Hi all:
> 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.
> Adam Doherty
> users-list mailing list
> users-list at monetdb.org
More information about the users-list