ORA-01861: 文字与格式字符串不匹配 01861. 00000 -指定了日期格式还是报错

select '2014-06-16'AS 日期,
group_name AS 卡部,
DNIS AS 对方号码,
ANI AS 主叫号码,
'对方' AS 挂机

from N_USERINFO a full join N_CALLRECORD b on a.user_id = b.user_id

where b.ani_enter_time is not null
and ani_enter_time > to_date('2014-06-16 00:00:00','yyyy-mm-dd hh24:mi:ss')
and dnis_enter_time < to_date('2014-06-16 23:59:59','yyyy-mm-dd hh24:mi:ss')
and a.user_id is not null
and b.user_id is not null;

---

where b.ani_enter_time is not null --这个条件雀数根本多空脊余，下边都有大于来限制了

再一个
你ani_enter_time 和dnis_enter_time字段类顷亏首型是什么

---