摘要： 字段为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, 阅读全文

摘要： select ((TO_DATE(HANDUP_TIME, 'yyyy-mm-dd hh24:mi:ss')-TO_DATE(CALL_IN_SUCC_TIME, 'yyyy-mm-dd hh24:mi:ss'))*24*3600) AS CALL_DURATION from T_USER; 阅读全文