I have a table named "event" and the column I'm focusing on is named "start", it is DateTime-formated.
I simply need to fetch, in this table, all events which "start" date is within a given date's day.
For instance, here is a set of dates:
The Date() function extracts the date part of a date or date/time expression.
"SELECT * FROM `event` WHERE date(start) = date('2016-10-17 16:45:27')";