SQL列值如20100401010101如何用时间查询

SQL2005我查实直接查的select * from 表 where 时间 between '2010-04-01 00:00:00' and '2010-04-01 23:00:00'
查不出结果来。 select * from 表 where 时间 between '2010-04-01 00:00:00' and '2010-04-02 23:00:00'  
只能查出2010-04-01的结果。     
如何select * from 表 where 时间 between '2010-04-01 00:00:00' and '2010-04-01 23:00:00'查出时间段的结果。