KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Let say you have a class with a java.util.Date field. Maybe a To do class or an Event planner class. @Temporal(TemporalType.TIMESTAMP) private Date startTime; This will map to a datetime column in MySQL. There are use cases when you want to know precisely when this Event occurs. "What is scheduled for Aug 11, 2011 at 8 PM?" Sometimes you just want to know which events are planned for a specific date. "What is scheduled for August 11, 2011?" If your JPAQL is: SELECT blah blah etc. WHERE ti.startTime = :d1 and the parameter is a java.util.Date instance: query.setParameter("d1", date, TemporalType.DATE); your results will be restricted by the date but also the time. This is such a common use case that I'm surprised that there is no simple way to do this even in JPA 2.0. I'd rather not use a vendor specific hack nor play around with strings/substrings. How have you solved this problem?
Tags (comma-separated)
Save Edits
Cancel