MySQL DATETIME to DATE查询JPQL

Question

query = em.createQuery("SELECT COUNT(a) FROM Appointment a WHERE a.datetime >= ?1 and a.datetime < ?2");
query.setParameter(1, date1, TemporalType.DATE);
query.setParameter(1, date2, TemporalType.DATE);

所以JPQL没有DATE()函数。

 I've tried a.startDate >= day1 AND a.startDate < nextday but it is returning the count of every single appointment

Answer 1

此查询：

SELECT COUNT(a)
FROM Appointment a
WHERE DATE(a.startDate) = ?1

只有在Appointment中有一个名为a的列才有意义。这是不太可能的。你可能打算：

SELECT COUNT(*)
FROM Appointment a
WHERE DATE(a.startDate) = ?1