字段为String类型:
SELECT a.EXT5 AS ACC_ID,a.MOBILE AS ACC_NUM,a.EXT14 AS PROD_INST_ID,a.EXT1 AS DEBT_CYCLE, a.AGENT_ID AS AGENT_ID,b.PROJ_NAME,c.TASK_NAME,d.BATCH_NAME,a.CUST_NAME,a.MOBILE,a.CALLER, a.DISPLAY_TICKET_ID,a.AGENT_ID AS STAFF_ID,a.AGENT_NAME AS STAFF_NAME,e.GROUP_NAME,a.CALL_RESULT,a.CONTACT_RESULT, a.CALL_BEGINTIME,a.CALL_IN_SUCC_TIME,a.HANDUP_TIME, ((TO_DATE(a.HANDUP_TIME, 'yyyy-mm-dd hh24:mi:ss')-TO_DATE(a.CALL_IN_SUCC_TIME, 'yyyy-mm-dd hh24:mi:ss'))*24*3600) AS CALL_DURATION,a.CALL_DESC AS MEMO FROM T_OB_CALLHIS_506000_COPY a LEFT JOIN T_OB_PROJECT b ON a.PROJ_ID=b.PROJ_ID LEFT JOIN T_OB_TASK c ON a.TASK_ID=c.TASK_ID LEFT JOIN T_OB_CUST_BATCH d ON a.BATCH_ID=d.BATCH_ID LEFT JOIN T_OB_CSR_GROUP e ON a.GROUP_ID=e.GROUP_ID WHERE TO_DATE(a.CALL_BEGINTIME,'yyyy-mm-dd hh24:mi:ss')>TO_DATE('2018-10-25 19:46:23','yyyy-mm-dd hh24:mi:ss') AND TO_DATE(a.CALL_BEGINTIME,'yyyy-mm-dd hh24:mi:ss')<TO_DATE('2018-10-31 19:39:38','yyyy-mm-dd hh24:mi:ss');