Calculate Timestamp Concurrent Intervals

[c0dem0nkey]

Thanks Gandolf!

So now I created a sql statement like this..

select pollsiteid,checkintime,LAG(checkintime,1) OVER (order by checkintime) as t2,timestamp_diff_in_seconds(checkintime,LAG(checkintime,1) OVER (order by checkintime)) as secdif from LOG_FIELD_CHECKIN_HISTORY where pollsiteid = 510

Which gives me the difference between the two records.

Now..I'm not to sure how to indicate the concurrent intervals..especially between two dates.