Mybatis和Mybatis-Plus时间范围查询方式

<if test= "startTime!=null and startTime.trim() neq ''" >

    and date_format(create_time, '%Y-%m-%d %H:%i:%s' ) &gt;= str_to_date(#{startTime}, '%Y-%m-%d %H:%i:%s' )

  </if>

  <if test= "endTime!=null and endTime.trim() neq ''" >

    and date_format(create_time, '%Y-%m-%d %H:%i:%s' ) &lt;= str_to_date(#{endTime}, '%Y-%m-%d %H:%i:%s' )

  </if>

<if test= "startTime!=null and startTime.trim() neq ''" >

    and date_format(create_time, '%Y-%m-%d %H:%i:%s' ) &gt;= date_format(#{startTime}, '%Y-%m-%d %H:%i:%s' )

  </if>

  <if test= "endTime!=null and endTime.trim() neq ''" >

    and date_format(create_time, '%Y-%m-%d %H:%i:%s' ) &lt;= date_format(#{endTime}, '%Y-%m-%d %H:%i:%s' )

  </if>

Page<Record> page = new Page<>(page, limit);

  IPage<Record> result = iRecordService.page(page,

         new LambdaQueryWrapper<Record>()

             .apply(StrUtil.isNotBlank(start_date),

                     "date_format (optime,'%Y-%m-%d') >= date_format('" + start_date + "','%Y-%m-%d')" )

             .apply(StrUtil.isNotBlank(end_date),

                     "date_format (optime,'%Y-%m-%d') <= date_format('" + end_date + "','%Y-%m-%d')" )

             .orderByDesc(HmsFaceDetectLog::getOptime));

DateTimeFormatter df = DateTimeFormatter.ofPattern( "yyyy-MM-dd HH:mm:ss" );

QueryWrapper query = new QueryWrapper();

query.ge( "create_time" , LocalDateTime.parse( "2019-05-13 23:00:00" , df));

query.apply( "UNIX_TIMESTAMP(create_time) >= UNIX_TIMESTAMP('" + "2019-05-12 03:00:00" + "')" );