SQL Function Reference

DATE_SUB

Subtracts a time interval from a date or datetime value.

MySQL

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

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

MySQL

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