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;