Although it is very tempting to use
AND ... for a date range, it is problematical. Instead, this pattern avoids most problems:
WHERE x >= '2016-02-25' AND x < '2016-02-25' + INTERVAL 5 DAY
BETWEENis 'inclusive' thereby including the final date or second.
23:59:59is clumsy and wrong if you have microsecond resolution on a