How to calculate one day ago date time using MySQL October 1, 2015 by admin We should use the following statement to calculate one day ago date time using MySQL: SELECT NOW() - INTERVAL 1 DAY;