MySQL has builtin functions to add time intervals. See, from the command line, info mysql Reference Functions 'Date and time functions'. The DATE_ADD() function is what you want, together with CURDATE()