using 'between' query does not get last date
I have been using a simple query to retrieve records from my DB between a date range that is entered by the user.
my problem is that if I have records on the day of $_POST['date_1'] they will not show up. So lets say that a user entered 2009-01-01 for the start date and 2009-01-12 for the end date - my query returns all records from 1/1 to 1/11 - Why is this?? how do I include the records from 1/12 (or what ever the end date is)?
WHERE recordtime BETWEEN "' .$_POST['date_0'].'" AND "'.$_POST['date_1'].'"