JPQL SELECT 日期语句之间

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能在这里主题，但这个问题的解决方式不太可能帮助未来的读者。

8 年前已关闭。

Answer 1

尝试此查询（将 t.eventsDate 替换为 e.eventsDate）：

SELECT e FROM Events e WHERE e.eventsDate BETWEEN :startDate AND :endDate

Answer 2

public List<Student> findStudentByReports(Date startDate, Date endDate) {
    System.out.println("call findStudentMethd******************with this pattern"
                    + startDate
                    + endDate
                    + "*********************************************");

    return em
            .createQuery(
                    "' select attendence from Attendence attendence where attendence.admissionDate BETWEEN : startDate '' AND endDate ''"
                            + "'")
            .setParameter("startDate", startDate, TemporalType.DATE)
            .setParameter("endDate", endDate, TemporalType.DATE)
            .getResultList();

}