I have two tables in Database and both fields has the datetime columns I want to extract only the date part form the columns and compare it. MySql give the YYYY-MM-DD HH:MM:SS format and I can't compare because of the time difference even though the date is same.
SELECT * FROM table1;
SELECT * FROM table2;
table1.date == table2.date
How can I only compare date excluding time in PHP?