--- Lloyd Thomas <[EMAIL PROTECTED]> wrote:
> I have a query which calculates the number of events during an hour
> by the
> minute. It needs to work out which minute has the most events and
> the
> average events during that hour. So it should return an array of 60
> results
> for an hour where I can use the MAX() feature in php to find the peak
It's too bad Sqlite doesn't have the modulo operator, you could
select and group by the modulo of the seconds of each date and get
your nice groupings very simply. If you can write a user defined
function in whatever language you're using you might try that.
__________________________________
Do you Yahoo!?
The all-new My Yahoo! - What will yours do?
http://my.yahoo.com
