MySQL Between is not grabbing the end date?
===

I have a SQL:

SELECT ... FROM orders WHERE date_created BETWEEN '2012-07-30' AND '2012-07-30'

Gives me zero results although there's 1000+ entrys for date 2012-07-30.

I found out that the BETWEEN simply does not grab the END date, so if it was

BETWEEN '2012-07-28' AND '2012-07-30'

It would grab me entrys for 28, 29 but not 30.

How can I make so it also takes the end date itself too?!