--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote: > > It's too bad Sqlite doesn't have the modulo operator, > > The "%" operator gives you remainder after division, > which is very close to being a modulo operator.
Thanks! I went looking for the page in the documentation about expressions to see what math sqlite supported. I couldn't find it and assumed it didn't have all the math functions. Lloyd: Since it does have this operator please disregard my example showing how to create a user defined function. You can do what you want by using : select tm % 60 as second, count(*) from your_table Group by second The tm field must contain the time in seconds of your event. You'll get up to 60 result rows with 0 - 59. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
