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