时间区间查询核心代码

   <if test="startDate!=null">
                <![CDATA[and DATE_FORMAT(create_time, '%Y-%m-%d')>= DATE_FORMAT(#{startDate}, '%Y-%m-%d')]]>
            </if>
            <if test="endDate!=null">
                <![CDATA[and DATE_FORMAT(create_time, '%Y-%m-%d')<= DATE_FORMAT(#{endDate}, '%Y-%m-%d')]]>
    </if>

<el-form-item label="考核时间">
          <el-date-picker
            v-model="dateRange"
            style="width: 240px"
            value-format="yyyy-MM-dd"
            type="daterange"
            range-separator="-"
            start-placeholder="开始日期"
            end-placeholder="结束日期"
          ></el-date-picker>
 </el-form-item>