mysql get last date time of yesterday code example Example: how to get yesterday date in mysql SELECT SUBDATE(NOW(),1);