Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-01861 Literal Does Not Match Format String

ORA-01861 Literal Does Not Match Format String

From: <virgilbvm1_at_yahoo.com>
Date: 3 Aug 2006 13:12:55 -0700
Message-ID: <1154635974.992586.247360@75g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US