Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> ORA-01861 Literal Does Not Match Format String
I am using the following code:
Select trunc (To_Date (call_start_dt)),
count(*)
from IVRREPORTING.CALLDETAIL
where
(call_start_dt > '2006-07-01 00:00:00'
and
call_start_dt < '2006-07-31 00:00:00' and
id_calllogging is null)
group by
trunc (To_Date (call_start_dt))
Getting the following error:
ORA-01861 Literal Does Not Match Format String
Can anyone offer some advice? Received on Thu Aug 03 2006 - 15:12:55 CDT