Re: [SQL] finding gaps in dates

2004-11-16 Thread Pierre-Frédéric Caillaud
I have a logging application that should produce an entry in the database every minute or so, give or take a few seconds. I'm interested in finding out a: what minutes don't have a record and b: periods where the gap exceeded a certain amount of time. Is this not the same question ? An

[SQL] finding gaps in dates

2004-11-16 Thread Matt Nuzum
I have a logging application that should produce an entry in the database every minute or so, give or take a few seconds. I'm interested in finding out a: what minutes don't have a record and b: periods where the gap exceeded a certain amount of time. The only way I can think of to do it is to