How to select date of only today from datetime column in mysql
Date format is YYYY-MM-DD

SET @dt = '2017-01-03 00:00:00';
SELECT * FROM some_table
WHERE datefield &gt;= @dt AND datefield &lt; (@dt + INTERVAL 1 DAY);