subtract one month from date mysql code example Example: mysql subtract month from timestamp DATE_SUB((DATE_SUB(curdate(), INTERVAL 1 MONTH)), INTERVAL 4 DAY)