mysql时间区间的查询

SELECT * from suncco_activity_dynamicmsg  where show_time >= '2013-07-8 00:00:00' and show_time <= '2013-07-9 23:59:59';