select * from ...
where date between '2005-12-01 08:00' and '2005-12-01 08:30'

si je ne me trompe pas.