sql date vs subdate code example Example: mysql subdate SELECT SUBDATE(NOW(), INTERVAL 1 DAY); --Yesterday