compare php mysql date code example
Example 1: compare date mysql
SELECT *
FROM players
WHERE DATE(us_reg_date) BETWEEN '2000-07-05' AND '2011-11-10'
Example 2: php compare dates
$date1 = "2021-01-15";
$date2 = "2021-01-18";
if ($date1 < $date2) {
echo "$date1 is earlier than $date2";
} else {
echo "$date1 is later than $date2";
}