Following is the query to select date from 00 :00 to today’s date −
mysql> select *from DemoTable where DueDate > DATE(NOW()) and DueDate < NOW();