The MySQL documentation on date and time formats can be found here.

In particular, take a look at DATE_ADD() and DATE_SUBTRACT(), which will return a date offset from a given date by a certain amount (i.e. 1 DAY).
Thanks,
TECHy