column_a>=时间A and column_a <= dateadd(day,时间A,1) order by column_a asc
select * from table where datetime between'2014-03-14 08:00:00' and '2014-03-15 08:00:00' order by datetime
不够明确，说细点
求数据库表结构，感觉题意有点不明确。
