HQL: time interval query

create · **Joined:** Fri Mar 05, 2004 9:19 am **Posts:** 5

Hi there,

I would like to perform a query on object which contains Date attribute and limit result set to specified date-time period and then specify also the time interval. For example, I'm interested in all objects between date1 and date2 and then inside this time period I would like to get all objects between 12:00 and 14:00. I know how to get objects between two dates but how to limit result also to specified time period? It is very important to not fetch whole data between these two dates and then enumerate items and find which one match specified time period but perofor this directly in query. I've tried to access minutes and houres attributes in Date object in the query but without the success.

Thanks in advance,

Sebastian Gil

emmanuel · **Posted:** Tue Sep 07, 2004 11:52 am

try using a specific function of your DB vendor

bertrand · **Posted:** Tue Sep 07, 2004 2:49 pm

emmanuel wrote:

try using a specific function of your DB vendor

Our use two different properties to persist the date and time parts. You can then query them like this:

Code:

from MyEntity e where e.date >= :minDate and e.date < :maxDate and e.time >= :minTime and e.time < :maxTime

PS: make sure to use the DATE and TIME Hibernate types when mapping your properties...

create · **Joined:** Fri Mar 05, 2004 9:19 am **Posts:** 5

emmanuel wrote:

try using a specific function of your DB vendor

Thanks. I didn't know that Hibernate supports native SQL injection in HQL. Very powerful feature. Once again I'm very impressed on implementation.

create · **Joined:** Fri Mar 05, 2004 9:19 am **Posts:** 5

bertrand wrote:

emmanuel wrote:

try using a specific function of your DB vendor

Our use two different properties to persist the date and time parts. You can then query them like this:

Code:

from MyEntity e where e.date >= :minDate and e.date < :maxDate and e.time >= :minTime and e.time < :maxTime

PS: make sure to use the DATE and TIME Hibernate types when mapping your properties...

Thanks for the hint. Unfortunatelly I cannot modify anything in database. I have to support legacy system.