我想判断这个日期最小值和参数比较,但是怎么设置都报错,求大神指导select co.orderno,co.orderStatus,ds.licensePlate, -- 车牌号Min(ds.date) as rq,(ds.odometerEndMileage-ds.odometerStartMileage) as lc,-- 里程ds.operateMode, -- 经营模式:0-公司化;1- 全资; 2- 合资; 3-责任ds.workOrderId,ds.status,-- 0-待执行;1-执行中;2-已完成;3-已改派;4-已取消 '1' bc,-- 班次ds.orgName -- 企业名称from charter_order coleft join dispatch_vehicle ds on co.orderno= ds.orderid-- left join charter_journey cj on co.orderno= cj.ordernowhere co.orderStatus=7 and ds.status =2 AND left(rq,10) >= '${sj}' AND left(rq,10) <= '${sj2}' group by co.orderno,ds.licensePlate