Function Reference
DATE_ADD
Adds a time interval to a date or datetime value.
MySQL 8.1
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 8.1
SELECT DATE_ADD(date, INTERVAL 7 DAY)
FROM Payments;MySQL 8.1
SELECT member_name,
DATE_ADD(birthday, INTERVAL 1 YEAR)
FROM FamilyMembers;