Hibernate version: 2

Name and version of the database you are using: Oracle 8

I am running a date based search where i am trying to find records within a certain time range, however when I specify a start and end date/time that occur on the same day as the record I am expecting in the result, it doesn't come back

ie.
Database table foo:
record1, startDate = 01/10/2005 10:00:00

HQL:
from foo as obj where obj.startDate >= ? and obj.startDate <= ?

where arg 1 is a date:
01/10/2005 00:00:01

and arg 2 is a date:
01/10/2005 23:59:59

No result returned.

The weird thing is, when I set arg 2 to the following day (02/10/2005 23:59:59), the record is correctly returned?

What method are you using to set your parameters on the query?

It sounds like you're losing your time information when you set your parameters. Are you using setDate()? If so, you might try converting your parameters to TimeStamps and using setTimeStamp(). Not sure how setDate() is supposed to behave, though....

I was using setDate() and using setTimeStamp() has resolved my problem!

Thanks heaps!

I didn't know about setTimestamp(). I assumed that because my database mapping in my hibernate mapping file (see below) contained a timestamp, using the setDate() method would perform time based comparisons (Wrong). The Hibernate API (Query object) is not particularly helpful with documentation on these methods.

<property name="startDate" type="timestamp" column="START_DATE" not-null="true" />