This will only select payments created in the past week if I'm running this query on May 1st, 2014. Check out the `current_date` function in the [Postgres date/time documentation](http://www.postgresql.org/docs/9.3/static/functions-datetime.html).