I have been trying to retrieve records from the database that match a certain date. For that i have using following query :

query = session.createCriteria(Event.class)
.add(Expression.eq("dateOfEvent", objDate))
.list();

where event is mine bean class
objDate is of type java.util.Date (i have also tried it as java.sql.Date)

and dateOfEvent maps to Date_of_event (of type DateTime) in the SQL Server 2000 database.

But this query does not returns any thing.

Please help me out.


Sandy

Using equality with Dates is not a great idea. You should use date ranges.

"where date > :start and date < :end"

thanxs a lot.
the idea u gave worked beautifully.

but i was nit able to uderstand one thing that
for date < :end it returned me records with date less then end. fine

but for date > :start it returned me records having dates greater than and equal to start. why????????.

again thanx