I am using Hibernat 3.1.3 with MySQL 5.0.19.

I have a class ChangeHistory that has a property actionTime of type timestamp. I want to use the Criteria facility to add an equality restriction on actionTime for a Date (not Timestamp). The native SQL would be:

select * from change_history where date(action_time) = '2005-11-30'.

How do I express this using the Criteria API? I am using DetachedCriteria.

Thanks,
Vidur

Write your own UserType.

Not sure I understand the solution. Do I need to write a custom UserType for each function that I need to call? If that's the case, then how would one use the same property with different functions?

I was hoping the solution would be something simpler such as Restrictions.sqlRestriction ("date(changeHistory.actionTime) = ?") which doesn't work as the changeHistory.actionTime is not translated to the column name.

Thanks,
Vidur

What exactly are you trying to do?
And where is the problem?

With Restrictions.sqlRestriction you probably have to assign alias.