grabbing date of last Sunday?

["blackwater dev" <blackwaterdev@xxxxxxxxx>]

How can I grab the date from the last Sunday based on when I run the query?

For example I run it today, and I need to date of 10-5-08, if I ran it next week, I would want 10-12-08, etc.


Thanks!