Обсуждение: Re: [GENERAL] SELECT Date

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

Use the function age() somewhat like this:

select * from sometable
where date_part( 'epoch' , age( 'now', somedate ) ) > 604800

The 'epoch' date part is the total number of seconds between the two dates.
For other variations, see:

http://www/postgresql.org/docs/user/functions1574.htm