Search Postgresql Archives

Re: date ranges in where

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux