Horton

SELECT Date

Andy <alewis@mpsi.net>

View thread View on postgr.es
From: Andy Lewis <alewis@mpsi.net>
To: PostgreSQL mailinglist <pgsql-general@postgreSQL.org>
Date: 1998-10-08T18:45:34Z
Lists: pgsql-general 
I have a table with somedate defined as date.

I want to select all rows that are from todays date back to 7 days
ago. Or in this case 10-1-1998.

data in the somedate fields appear as: 10-7-1998


Can someone help?

Thanks in advance