Home > mailing lists

date ranges in where - Mailing list pgsql-general

From	Miguel Miranda
Subject	date ranges in where
Date	May 6, 2009 21:12:50
Msg-id	aa6b08350905061412x63defb39oe58e126510354a28@mail.gmail.com Whole thread Raw
Responses	Re: date ranges in where (Raymond O'Donnell <rod@iol.ie>) Re: date ranges in where (Erik Jones <ejones@engineyard.com>) Re: date ranges in where (Adrian Klaver <aklaver@comcast.net>)
List	pgsql-general

Tree view

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...

pgsql-general by date:

From: Richard Sickler
Date: 06 May 2009, 20:59:17
Subject: Question on pg_xlog and pg_control placement

From: Raymond O'Donnell
Date: 06 May 2009, 21:16:55
Subject: Re: date ranges in where

date ranges in where - Mailing list pgsql-general

Previous

Next