date range for the current week

how can i get the date range for the current week, from sunday to saturday? i.e., this week would be 24-30. i've tried playing around with a the date function but can't figure out how to do this. a mysql query would be ok, too.