Hibernate version:2.1.5

Hi,
I'm using the Criteria object to create my query. I want a list of records between two given dates (inclusive of both the dates)...

here is my code....

List ueis = session.createCriteria(UeiInstance.class)
.add( Expression.ge("CreateStamp", sd))
.add( Expression.le("CreateStamp", ed))

if sd -> 2004-08-03 00:00:00
& ed -> 2004-08-17 23:59:00

it is displaying...records for all days between 03 & 16.. but it is not displaying for 17th.. can anyone.. tell me what is wrong? I have even tried.. using.. Expression.between("CreateStamp",sd,ed)... even then, I don't get data for 17th...

Looks like the comparison is made on DATE and not on DATETIME...
Check your mapping and/or database model.
Have a look at the different Hibernate types and how they map on the db - mainly date, time and timestamp.