MySQL Date Arithmetic
DevShed takes a look at the API for doing date and time arithmetic inside MySQL. It's almost always better to do basic date calculations inside the database before you get the result set back, since that way you're getting "good data" from the database without having to "massage" it in your application-layer code.