Can not query time portion of data time field in JBoss EAP
Issue
We have a data type which is stored in the database as a datetime.
That field is mapped as follows:
@Temporal(TemporalType.TIME)
java.util.Date getDepartureTime() { ... }
When this field is displayed it performs as expected and the date is not what is contained in the database, but the correct time with a date of 01/018/1970.
The problem I am encountering is I need to query the object based on time alone. For instance how many objects have a departureDate between 7:00 and 10:00 irrelevant of date.
Can a temporal field with a type of time be used to query based on time alone? If not how may this be accomplished?
Environment
- Red Hat JBoss Enterprise Application Platform (EAP)
- 5.x
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
