JPA查询时间(localdatetime)间隔数据问题

1.需求mysql查询近7天数据

String strat = LocalDate.now()+" 24:00:00";//获取今天日期
LocalDateTime rightNow = LocalDateTime.parse(strat, DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss"));//获取今天日期
LocalDateTime sevenDaysAgo = rightNow.minusDays(7);//七天前的日期
JPAQuery<DocInfoPageDto> jpaQuery = queryFactory.select(Projections.bean(DocInfoPageDto.class, resultMap))
        .from(qDocumentInfo)
        .leftJoin(qDocUpgrade).on(qDocumentInfo.id.eq(qDocUpgrade.docId))
        .where(new OptionalBuilder().and(qDocUpgrade.createTime.loe(rightNow)).and(qDocUpgrade.createTime.gt(sevenDaysAgo)))
        .orderBy(qDocUpgrade.createTime.desc());