Get records between date for example in mysql 2009-08-11 to current date 2009-08-11 is to retrieve all date , this is just an example I have tried WHERE time between date(time) and DATE(time) = CURDATE();