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;