Search Postgresql Archives

date ranges in where

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

To: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>
Subject: date ranges in where
From: Miguel Miranda <miguel.mirandag@xxxxxxxxx>
Date: Wed, 6 May 2009 15:12:47 -0600

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

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

Follow-Ups:
- Re: date ranges in where
  - From: Jasen Betts
- Re: date ranges in where
  - From: Adrian Klaver
- Re: date ranges in where
  - From: Erik Jones
- Re: date ranges in where
  - From: Raymond O'Donnell

Prev by Date: Question on pg_xlog and pg_control placement
Next by Date: Re: date ranges in where
Previous by thread: Question on pg_xlog and pg_control placement
Next by thread: Re: date ranges in where
Index(es):
- Date
- Thread

[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