Compare date only (without time) in JPA2 (JPQL)

datetime jpa date jpa-2.0 jpql
atamanroman picture atamanroman · May 4, 2011 · Viewed 45.4k times · Source

Im trying to compare Calendars with JPA2. The query looks somewhat like that:

TypedQuery<X> q = em.createQuery("select r from Record r where r.calendar= :calendar", X.class);
Calendar c = foo(); // setting fields and stuff
q.setParameter("calendar", c);

This, however, compares the date + time. I want to know if MM:DD:YYYY is equal and do not care about the time. Is there a nice way to do that in JPA2 or do I have to create a native query?

I tried setting HH:MM:SS:... to zero before saving it in the db but I don't know if this is very wise, regarding time zones and daylight saving and stuff.

Answer

Ot&#225;vio Garcia picture Otávio Garcia · May 8, 2011 
q.setParameter("calendar", c, TemporalType.DATE)

You can pass the TemporalType.DATE to setParameter method to truncate the date+time.

Related questions

JPA Storing OffsetDateTime with ZoneOffset

I have the following entity class: @Entity public class Event { private OffsetDateTime startDateTime; // ... } However, persisting and then reading the entity to/from the database with JPA 2.2 results in a loss of information: the ZoneOffset of startDateTime changes to UTC (the …

Read More
How to store Java Date to Mysql datetime with JPA

Can any body tell me how can I store Java Date to Mysql datetime...? When I am trying to do so...only date is stored and time remain 00:00:00 in Mysql date stores like this... 2009-09-22 00:00:00 I want not only …

Read More
How to store date/time and timestamps in UTC time zone with JPA and Hibernate

How can I configure JPA/Hibernate to store a date/time in the database as UTC (GMT) time zone? Consider this annotated JPA entity: public class Event { @Id public int id; @Temporal(TemporalType.TIMESTAMP) public java.util.Date date; } If …

Read More