Re: Finding a date

XaFTek wrote:

> Hi !
>
> I have a table named
> checklog
> (
> checklogdate date not null,
> idapp integer not null
> )
>
> By example for idapp=10
> I have thoses lines in the table (date format is DD/MM/YY):
> 20/10/02 10
> 12/10/02 10
> 10/10/02 10
> 09/10/02 10
> 06/08/02 10
> 05/08/02 10
> 04/08/02 10
> 02/08/02 10
> 01/08/02 10
> 30/06/02 10
>
> There is only 1 line by day for an idapp.
>
> Starting down from the date 12/10/02 I want to know when my checklog
> "start record".
> Start record is where checklog began to record my idapp within a 7
> days no recording gap.
>
> For this example I have a session recording form 09/10/02 to 12/10/02
> because there is more than 7 days between 09/10/02 and 06/08/02.
> I have also a session recording from 06/08/02 to 01/08/02.
>
> How can I do that in SQL ?
>
> Thank's in advance.

I am sure it is a matter of language ... and your English is far better than my French. But I can not understand what you are trying to do.

When posting again be sure to include your exact Oracle version.

Daniel Morgan Received on Wed Oct 23 2002 - 17:49:15 CDT