[Oracle] Caused by: oracle.jdbc.OracleDatabaseException: ORA-01861

ERROR  : ORA-01861  

 

I am trying to insert data into an existing table and keep receiving an error.

This happens because A literal with a format string.

 

 

request 

{
  date : '2022-09-25 16:17:59'
}

 

receive

String date;

 

solution 

TO_DATE(#{date},'YYYY-MM-DD HH24:MI:SS')