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