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??