oracle查询时间段

select count(*) tt from crm_cisco_call_detail
where DateTime between to_date('2016-4-5 00:00:00','yyyy-mm-dd hh24:mi:ss') and to_date('2016-05-02','yyyy-mm-dd hh24:mi:ss')

原文地址:https://www.cnblogs.com/xiaohuihui123/p/5404295.html