在Eclipse中框架SSM整合sql server 数据库 中的包含不能使用

    <select id="flightdetails" resultType="com.flight.bean.QARflight">
        select id,FOCFlightDate,FOCFLightNum,FOCTakeOff3,FOCArrive3,FOCACNum,FOCACType,
            FOCTrueTakeOffTime,FOCTrueLandingTime,FOCCaptain,FOCOperator,
            QARBeginTime,QAREndTime,idQARfromout,state,QACVRBeginTime,
            QACVREndTime from 表where Convert(varchar(10),FOCFlightDate,120) between '%${前台传入时间值a}%' and '%${前台传入时间值b}%'

    </select>

把 Convert(varchar(10),FOCFlightDate,120) 改成FOCFlightDate字段就报时间类型转换错误。

请大家赐教啊