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

posted @ 2016-04-18 14:13  LittlePenguin  阅读(299)  评论(0编辑  收藏  举报