sorry, i edited the date, the correct one is 05-03-2009 12:00:00 AM
If i group by day, it count 1 user for day 2009-05-03 in the output, so it adds 1 to the total count of the range regards On Wed, May 6, 2009 at 3:51 PM, Erik Jones <ejo...@engineyard.com> wrote: > > On May 6, 2009, at 2:48 PM, Miguel Miranda wrote: > > Well, i tried all your sugestions, and i found some funny issues, i use >> the query to count exactly in a day by day basis, and running the query with >> >> WHERE lastlogin >= '2009-05-01' AND lastlogin < '2009-05-03' >> >> OR >> >> WHERE lastlogin >= 'X' AND lastlogin <= 'Y' + '1 day'::interval >> >> >> it includes the 0 hours of day 3: >> >> 05-02-2009 12:00:00 AM >> > > No, 05-02-2009 12:00:00 AM is the midnight point between 2009-05-01 and > 2009-05-02. > > > Erik Jones, Database Administrator > Engine Yard > Support, Scalability, Reliability > 866.518.9273 x 260 > Location: US/Pacific > IRC: mage2k > > > > > >
