Re: date ranges in where

From: Adrian Klaver <aklaver(at)comcast(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Miguel Miranda <miguel(dot)mirandag(at)gmail(dot)com>
Subject: Re: date ranges in where
Date: 2009-05-06 21:19:07
Message-ID: 200905061419.07510.aklaver@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)comcast(dot)net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2009-05-06 21:19:33 Re: [GENERAL] how to select temp table
Previous Message Erik Jones 2009-05-06 21:17:36 Re: date ranges in where