Using SQL to check time intervals

Hi all,

I am attempting to do "COUNT(*)"s on time intervals from a DATE field.

The ROUND and TRUNC functions seem to round to something that is part of the format models, but I need something a little more complicated, like every 10 minutes or every 15 minutes. I have used substrings to do 10 minute ranges (by triming off the last digit of the minute), but thats pretty non-elegant.

I also tried a PL/SQL procedure that did the "flooring to the interval", but I can't use it in the GROUP BY function.

Anybody got any ideas???

Thanks

Jeff Hays
hays_at_magicnet.net Received on Mon Apr 15 1996 - 00:00:00 CEST