MySQL "between" clause not inclusive?
The field dob
probably has a time component.
To truncate it out:
select * from person
where CAST(dob AS DATE) between '2011-01-01' and '2011-01-31'
From the MySQL-manual:
This is equivalent to the expression (min <= expr AND expr <= max)