MySQL Function Reference

DATE_SUB

Subtracts a time interval from a date or datetime value.

MySQL 8.1

DATE_SUB(date, INTERVAL expr unit)

date

The starting date or datetime.

INTERVAL expr unit

The interval to subtract (e.g., INTERVAL 1 MONTH).

Examples

MySQL 8.1

SELECT DATE_SUB(date, INTERVAL 1 MONTH)
FROM Payments;

MySQL 8.1

SELECT member_name,
	DATE_SUB(birthday, INTERVAL 10 DAY)
FROM FamilyMembers;