MySQL DATETIME to DATE query 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);

So JPQL does not have a DATE() function.
I've tried a.startDate >= day1 AND a.startDate < nextday but it is returning the count of every single appointment

Yes. The ?1 is for the parameter value. The error is marking the first parenthesis in DATE(a.startDate) — Entity
– Entity, Commented Nov 21, 2015 at 2:34
Because DATE is not a valid JPQL function. Read the JPA spec and any decent JPQL docs — Neil Stockton
– Neil Stockton, Commented Nov 21, 2015 at 3:35

Gordon Linoff · Accepted Answer · 2015-11-21 03:32:49Z

This query:

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

only makes sense of there is a column called a in Appointment. That is unlikely. You probably intend:

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

@Entity . . . Your question has the "mysql" tag. And, that syntax doesn't really make sense in MySQL.

Collectives™ on Stack Overflow

MySQL DATETIME to DATE query JPQL

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related