We should use the following statement to calculate one day ago date time using MySQL:

SELECT NOW() - INTERVAL 1 DAY;