SQL Function Reference

DATE_ADD
Adds a time interval to a date or datetime value.
MySQL
DATE_ADD(date, INTERVAL expr unit)
date
The starting date or datetime.
INTERVAL expr unit
The interval to add (e.g., INTERVAL 7 DAY).
Supports various time units: SECOND, MINUTE, HOUR, DAY, WEEK, MONTH,QUARTER, YEAR, and more.
Examples
MySQL
SELECT DATE_ADD(date, INTERVAL 7 DAY)
FROM Payments;
MySQL
SELECT member_name,
	DATE_ADD(birthday, INTERVAL 1 YEAR)
FROM FamilyMembers;