MySQL round date to the start of the week and month

Viewed 23793

For "2012-07-12", how can I get the start of the week, i.e., "2012-07-08", and start of the month, i.e., "2012-07-01"?

5 Answers
Related