topic Re: OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string in QlikView

OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

master_student — Mon, 04 Jul 2016 09:28:26 GMT

Hello community,

I need to get the result of a query; Date today.

The date field format is 063016. here's my query :

SELECT ....

FROM

WHERE

tt.STARTOFCHARGINGDATE = TO_DATE (TO_CHAR (SYSDATE , 'MMDDYY'), 'MMDDYY')

It didn't work; Error : OraOLEDB, ErrorMsg: ORA-01861: literal does not match format string

Any idea please?

Thanks

master_student — Mon, 04 Jul 2016 11:33:53 GMT

for your info, the data type of the stratofcharging field is varchar. see bellow :

Thanks in advance.

Gysbert_Wassenaar — Mon, 04 Jul 2016 11:59:03 GMT

STARTOFCHARGINGDATE is a varchar, i.e. text. Your comparing a text value with a date value. Perhaps this works:

SELECT ....

FROM

WHERE

tt.STARTOFCHARGINGDATE = TO_CHAR (SYSDATE , 'MMDDYY')

ejvanmastrigt — Mon, 04 Jul 2016 12:02:10 GMT

TO_DATE() converts your string to a date.

Since the data type of STARTOFCHARGINGDATE is VARCHAR2, using function TO_CHAR should do it:

WHERE STARTOFCHARGINGDATE = TO_CHAR(SYSDATE, 'MMDDYY')

Best regards,

Erik