JPA + PostgreSQL按日期过滤，精确到分钟

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import java.util.Date;

public class MyRepository {

    @PersistenceContext
    private EntityManager entityManager;

    public List<MyEntity> filterByDate(Date startDate, Date endDate) {
        Query query = entityManager.createQuery("SELECT e FROM MyEntity e WHERE e.dateField BETWEEN :startDate AND :endDate");
        query.setParameter("startDate", startDate);
        query.setParameter("endDate", endDate);
        return query.getResultList();
    }
}

import javax.persistence.EntityManager;
import javax.persistence.PersistenceContext;
import javax.persistence.Query;
import java.util.Date;

public class MyRepository {

    @PersistenceContext
    private EntityManager entityManager;

    public List<MyEntity> filterByDateTime(Date dateTime) {
        Query query = entityManager.createQuery("SELECT e FROM MyEntity e WHERE FUNCTION('date_trunc', 'minute', e.dateTimeField) = :dateTime");
        query.setParameter("dateTime", dateTime);
        return query.getResultList();
    }
}