JPQL SELECT between date statement

Question

I would like to convert this SQL statement to a JPQL equivalent   SELECT   FROM events WHERE events date BETWEEN  2011-01-01  AND  2011-03-31     This correctly retrieves the information from the table events   In my Events entity           Column name    events date         Temporal TemporalType DATE       private Date eventsDate    So far this is what I have but it is not working   public List lt Events gt  findAllEvents Date startDate  Date endDate          List lt Events gt  allEvents   entityManager createQuery       SELECT e FROM Events e WHERE t eventsDate BETWEEN  startDate AND  endDate        setParameter  startDate   startDate  TemporalType DATE       setParameter  endDate   endDate  TemporalType DATE       getResultList      return allEvents         What am I doing wrong  Thanks

User · Accepted Answer

Try this query  replace t eventsDate with e eventsDate    SELECT e FROM Events e WHERE e eventsDate BETWEEN  startDate AND  endDate

User · Answer

public List lt Student gt  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

[java] JPQL SELECT between date statement

Examples related to java

Examples related to sql

Examples related to jpa

Examples related to jpql