mysql SUBDATE with datetime code example Example: mysql subdate SELECT SUBDATE(NOW(), INTERVAL 1 DAY); --Yesterday