oracle : select * from A where occurtime >= to_date('2013-9-18 00:00:00','yyyy-MM-dd hh:mm:ss') and occurtime <= to_date('2013-9-18 01:00:00','yyyy-MM-dd hh:mm:ss')
第2个回答 2013-09-18
select * from table where occurtime between unix_timestamp('2013-9-18 00:00:00') and unix_timestamp('2013-9-18 01:00:00');