ORA-01861: 文字与格式字符串不匹配

ORA-01861: 文字与格式字符串不匹配

    sql.append( "insert into QA_DCS_DATA ");
   sql.append(" select QA_DCS_DATA_ID_SEQ.nextval,to_date(:flightDate,'yyyy-MM-dd'),:depAirport,:flightSumI,:psgSumI," +
    ":bagPicSumI,:bagWeightSumI,:flightSumD,:psgSumD,:bagPicSumD,:bagWeightSumD from dual where  not exists" +
    "(select * from QA_DCS_DATA d where to_char(d.FLIGHT_DATE,'yyyy-MM-dd')=:flightDateP and d.DEP_AIRPORT=:depAirportP)");

问题： 当为fligthDate 设置值时，insertQ.setDate("flightDate",dcsData.getFlightDate());     可是sql明显是需要一个字符串

解决问题：  insertQ.setString("flightDate",DateUtil.date2String(dcsData.getFlightDate(), "yyyy-MM-dd"));  已某种格式转换为字符串就可以了