将查询保存在localdatetime中，并为localdate版本添加api似乎更为严格。

@Query("select m from MyClass m " +
                "where m.dateTime >= :startDate and m.dateTime < :endDate")
findAllByTradeTimeBetween(@Param("startDate") LocalDateTime startDate, 
                          @Param("endDate") LocalDateTime endDate);

findAllByTradeTimeBetween(LocalDate startDate, LocalDate endDate) {
    return findAllByTradeTimeBetween(startDate.atStartOfDay(),
                                     endDate.plusDays(1).atStartOfDay());
}

这将打开一些可疑用法的api（使用localdatetimes）。

您可以使用javax.persistence.attributeconverter来自动化日期格式之间的转换。下面是converter类，它将自动将localdatetime对象转换为localdate和viceversa：

@SuppressWarnings("UnusedDeclaration")
    @Converter(autoApply = true)
    public class LocalDateConverter implements AttributeConverter<LocalDateTime, LocalDate> {
        @Override
        public LocalDate convertToDatabaseColumn(LocalDateTime localDateTime) {
            //convert localDateTime to LocalDate
        }

        @Override
        public LocalDateTime convertToEntityAttribute(LocalDate localDate) {
            // convert localDate to LocalDateTime
        }
    }