PHP time function and SQL time calculation
Original link: https://www.mqllin.cn/archives/190.html “` strtotime(‘2020-01-30 12:00’)); //specified date and time stamp time(); //current timestamp curdate() //Indicates the date of the day “` Count the log sql statements of the previous day: “` select * from bean where date(log_time) = date_sub(curdate(), interval 1 day); “` Requirement: Statistics start from yesterday and count the logs of the […]
PHP time function and SQL time calculation Read More »