如何在mysql中选择日期和时间之间的行？

There is a table that has three columns. ID, Date and Time. I need to select rows that are between 2014/01/04 and 2014/06/15 (specified by green) where start time is 12:00:00 and finish time is 20:00:00 (specified by blue). How can I select all blue rows?There is a table that has three columns. ID, Da