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

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
        <include refid="Base_Column_List"></include>
        from cc_notice ccn
        where 1= 1
            and ccn.online_status = 1
            and notice_type = #{type}
        <if test="startTime != null">
            AND DATE_FORMAT(publish_time,'%Y-%m-%d') &gt;= DATE_FORMAT(#{startTime},'%Y-%m-%d')
        </if>
        <if test="endTime != null">
            AND DATE_FORMAT(publish_time,'%Y-%m-%d') &lt;= DATE_FORMAT(#{endTime},'%Y-%m-%d')
        </if>
        and ccn.isdelete = 0
        ORDER BY ccn.publish_time desc