AnsweredAssumed Answered

I get Embedded message: Errors occurred while building or executing SQL statement: ORA-01861: literal does not match format string ; Caused by: ORA-01861: literal does not match format string

Question asked by gouthamr388096 on Mar 13, 2017

I am getting Embedded message: Errors occurred while building or executing SQL statement: ORA-01861: literal does not match format string ; Caused by: ORA-01861: literal does not match format string  Error when I am doing a select query. The error comes right in the connector itself. I am wondering what could cause this and which field is throwging this error. 

What i do not understand is why I get this error when I am doing a SELECT query a. Any pointers/feedback would be helpful.

 

Here is the query

SELECT AMINOA, CNA, CHRO, COPYNUMBER, CREATEDT, EXO, GENE, LENGTHs, DISPLAYNAME, MODDT, ALLELEFREQUENCY, MUTATION, POSITION, RECORDID, CATEGORY, REPORTRECORDID, EEFFECT, TYPE, VARIANTDISPLAYNAME FROM ALTERATION_FREQUENCIES
WHERE CREATEDT > ?
ORDER BY CREATEDT ASC

and

SELECT ACCOUNT, BILLING, COLLDATE, CTYPE, FINALREPORTDATE, GHCLIENTID, INFORECORDID, PERMITTEDTOCONTACT, LATESTREPORTDATE, MODDT, COUNTRY, DOB, EMAILADDRESS, FIRSTNAME, PATIENTGENDER, LASTNAME,MIDDLENAME, PRECORDID, PFIRSTNAME, PLASTNAME, PMIDDLENAME, PRECORDID, PBARCODE, PRACTICENAME, RECEIVEDDATE, GENERATIONSTATUS, REPORTPDFFILENAME, REPORTSTATUS, REQUESTID, REQUESTTYPE, SPHYCLIENTID, SFIRSTNAME, SLASTNAME, SMIDDLENAME, SRECORDID, SFDCCONTACTID, TRFBARCODE, USERNAME, U_GHCLIENTID FROM REQUEST_SUMMARIES
WHERE RECEIVEDDATE > ?
ORDER BY RECEIVEDDATE ASC

 

Thanks

KG

Outcomes