Assuming you have a column in a table of type DATETIME, and you want to filter it based on dates and time as well, BETWEEN will be helpful.
Listing 1. Sample Code
SELECT * FROM table_name WHERE column_name between '2017-06-10' and '2017-06-12 18:00:00'
Please note: Here the first criteria ‘2017-06-10’ is equivalent to ‘2017-06-10 00:00:00’. Hence the filtering happens for all records starting at 00:00:00 hours on 10-Jun-2017 to 18:00:00 hours on 12-Jun-2017.