Hi,
I have been trying to query based on a date field in oracle but it fails to return any results.

The mapping for the date column is:
<property name="createTime" column="CREATE_TIME"
type="date"
not-null="false"
length="7"/>

The criteria query I utilize is:

public List getFormListWithinCreateTimeRange(Date lo, Date hi,Session s)
{
List forms=s.createCriteria(Form.class).add(Expression.gt("createTime",lo)).list();
return forms;
}

Jeevak