tags:

views:

73

answers:

0

We are using detach criteria and adding restrictions to equate the date. But the problem is the date in the database column contains time as well and i just want to do some query againts the date part.

DetachedCriteria query = DetachedCriteria.For<RefundRequestedTicket>();
query.Add(Restrictions.Eq("ValidUntil", findRefundRequestedTicketsRequest.ValidUntil));

ValidUntil in database contains time and findRefundRequestedTicketsRequest.ValidUntil contains only date, this never returns me 0 count.

Is there anyway just to check the date part with detachcriteria??