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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
