I am using the Query interface to find objects between a given data range,

"from ObjectA oa where oa.lastModifiedDate >= ? and oa.lastModifiedDatae <=?

Where I am dynamically binding the date values. It works fine except when both the start and end date or the same date but different times.

I looked at the query and it has the 00:00:000 ( hr:min;sec) value for both even though the actual date has the right hr:min:sec on it
( 'Jul 21 2004 12:00:00:000AM', 'Jul 21 2004 12:00:00:000AM', )

Is there some setting/date format I have to do have hr:min:sec included?

thanks
Rama

Can you post the code where you actually bind the values? I'm thinking you might be using a datatype that is scrapping the time.

test

This is the Query.
String query = "from A as cls where cls.lastModifiedDate>= ? and cls.lastModifiedDate <=?"

List valueList = new ArrayList();
List typeList = new ArrayList();

java.util.Date beginDate =....
java.util.Date endDate = ....
valueList.add(beginDate);
typeList.add(Hibernate.DATE);
valueList.add(endDate);
typeList.add(Hibernate.DATE);

List returnList = session.find(query,valueList,typeList);

Did you ever find a solution to this problem?

You want timestamp, not date