sql 时间段搜索select * from live_room where begintime to_date(2011-05-07 00:00:00,yyyy-MM-dd
sql 时间段搜索
select * from live_room where
begintime >= to_date('2011-05-07 00:00:00','yyyy-MM-dd hh24:mi:ss')
and begintime<= to_date('2011-05-08 00:00:00','yyyy-MM-dd hh24:mi:ss')