java - Spring Data JPA 时间戳比较

Question

我正在尝试将 native 查询转换为规范。我陷入了这种情况:

....
WHERE
TIMESTAMP(D_DATA, D_TIME) >= '2015-06-23 05:46:53.000000'

有没有办法获得与规范相同的结果？

谢谢

Answer 1

感谢 Paul Vernon，我决定:

public static Specification<Transit>compareTimestamps(Timestamp timestamp){
    LocalTime localTime = timestamp.toLocalDateTime().toLocalTime();
    LocalDate localDate = timestamp.toLocalDateTime().toLocalDate();
    Specification<Transit> dateSpec = compareDateWithTimestamp(localDate);
    Specification<Transit> dateTimeSpec = compareDateAndTimeWithTimestamp(localDate, localTime);
    return where(dateSpec).or(dateTimeSpec);
}

private static <T>Specification<T> compareDateWithTimestamp(LocalDate localDate){
    return (Specification<T>) (root,query,cb) -> cb.greaterThan(root.get("dTrn"),localDate);
}
private static <T>Specification<T> compareDateAndTimeWithTimestamp(LocalDate localDate, LocalTime localTime){
    return (Specification<T>) (root, query, cb) -> {
        List<Predicate> predicates = new ArrayList<>();
        predicates.add(cb.equal(root.get("dTrn"),localDate));
        predicates.add(cb.greaterThanOrEqualTo(root.get("dTimTrn"),localTime));
        return cb.and(predicates.toArray(new Predicate[]{}));
    };
}