Re: date ranges in where - Mailing list pgsql-general

From Adrian Klaver
Subject Re: date ranges in where
Date
Msg-id 200905061419.07510.aklaver@comcast.net
Whole thread Raw
In response to date ranges in where  (Miguel Miranda <miguel.mirandag@gmail.com>)
Responses Re: date ranges in where
List pgsql-general
On Wednesday 06 May 2009 2:12:47 pm Miguel Miranda wrote:
> Hi, what is the recommended way to select a range of dates?
>
> Lets say a have a table with a lastlogin (timestamp) column and i want
> toknow what users logged in for last time between 2009-05-01 and
> 2009-05-02?
>
> I know that a simple
>
> where lastlogin between '2009-05-01' and '2009-05-02' doesnt work beacuse
> it doesnt include who logged in 2009-05-02 15:30:00, etc...

lastlogin between '2009-05-01' AND '2009-05-03'

--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: date ranges in where
Next
From: Eric Schwarzenbach
Date:
Subject: Re: XML -> PG ?