MySQL date and hour issue

I have read that MySQL has some issues regarding date type. I want to get a date interval taking into account the hour. My question is can I do a between query, or make a colum开发者_JAVA技巧n for the hour as well?

P.S:

select * from main where main.date between 01-06-11 07:59 and 01-06-11 15:59