Re: Looking for "gaps" (from a time perspective) in data
From: <ca111026_at_gmail.com>
Date: Fri, 10 Oct 2008 05:04:40 -0700 (PDT)
Message-ID: <1fe20455-c2f4-4499-b0e5-bc53b989589e@s9g2000prg.googlegroups.com>
Date: Fri, 10 Oct 2008 05:04:40 -0700 (PDT)
Message-ID: <1fe20455-c2f4-4499-b0e5-bc53b989589e@s9g2000prg.googlegroups.com>
Hi Jeremy,
Instead of looking at individual records it may be easier to analyze
the issue from statistical perspective.
Calculate number of records, average duration, and standard deviation
with averaging
over second/minute/hour - whatever is appropriate.
For example, for second
select
to_char(date_start,'YYYY-MM-DD HH24:MI:SS') d_start,
count(*) cnt,
avg((date_end - date_start)*24*3600) avg_duration
from tableA
group by
to_char(date_start,'YYYY-MM-DD HH24:MI:SS');
Received on Fri Oct 10 2008 - 07:04:40 CDT