Re: Fw: Count rows group by time intervals

Funny thing.
In mine, it works...
On mine, If I subtract one date  from the other I get the number of days in between...which is another integer, I guess. and '%'  is the modular operator. Doesnt it work like this on yours?

Which version are you using?

try

SELECT (date - '2007-01-01') % 2
FROM table

to see if you get zeroes and ones .