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

[master_student]

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]

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

Thanks in advance.

[Gysbert_Wassenaar · Accepted solution]

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]

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