Calculate Timestamp Concurrent Intervals

[gandolf989]

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.

Did you know you can subtract one date from another and find out the difference in time.