On Wednesday 06 May 2009 2:51:08 pm Erik Jones 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. The problem being that midnight is both the end of one day and the start of another. > > Erik Jones, Database Administrator > Engine Yard > Support, Scalability, Reliability > 866.518.9273 x 260 > Location: US/Pacific > IRC: mage2k -- Adrian Klaver aklaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
