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')