How can the DATE() function in MySQL be used to extract only the date part for comparison in PHP?

When using the DATE() function in MySQL to extract only the date part for comparison in PHP, you can retrieve the date as a string and then compare it with another date string in PHP. This can be useful when you want to compare dates without considering the time component. By using the DATE() function in MySQL, you can ensure that only the date part is extracted for comparison purposes. 

// Assuming $dbDate is the date fetched from MySQL and $phpDate is the date to compare in PHP
$dbDate = "2022-10-15 14:30:00";
$phpDate = date("Y-m-d");

if (date("Y-m-d", strtotime($dbDate)) == $phpDate) {
    echo "Dates match!";
} else {
    echo "Dates do not match!";
}

Keywords

MySQL DATE() function PHP comparison date part

Related Questions