数据库中时间有时分秒的查询优化

DATE_FORMAT(cross_time,'%Y-%m-%d') >= DATE_FORMAT(#startTime#,'%Y-%m-%d') 
 可以优化对于数据库时间中有时分秒的查询

 3.1： md文件的sql编写

SELECt
        @pageTag(){
            a.*
        @}
    FROM
        cc_car_pass a
    WHERe a.isdelete = 0
    @if(!isEmpty(entranceName)){
        and entrance_name like #'%'+entranceName+'%'#
    @}
    @if(!isEmpty(vehicleType)){
        and vehicle_type=#vehicleType#
    @}
    @if(!isEmpty(startTime)){
        AND DATE_FORMAT(cross_time,'%Y-%m-%d') >= DATE_FORMAT(#startTime#,'%Y-%m-%d')
    @}
    @if(!isEmpty(endTime)){
        AND DATE_FORMAT(cross_time,'%Y-%m-%d') <= DATE_FORMAT(#endTime#,'%Y-%m-%d')
    @}
    ORDER BY a.cross_time desc

  
  3.2： mapper文件编写

select
        
        from cc_notice ccn
        where 1= 1
            and ccn.online_status = 1
            and notice_type = #{type}
        
            AND DATE_FORMAT(publish_time,'%Y-%m-%d') >= DATE_FORMAT(#{startTime},'%Y-%m-%d')
        
        
            AND DATE_FORMAT(publish_time,'%Y-%m-%d') <= DATE_FORMAT(#{endTime},'%Y-%m-%d')
        
        and ccn.isdelete = 0
        ORDER BY ccn.publish_time desc