How to compare only the MM/dd/yyyy part of two dates with a detached criteria?

Question

I have to dates in my query: ExpectedEnd and TerminationDate.
I need to find a query that returns records whenever the ExpectedEnd is at the same day as TerminationDate.
How can it be done using detached criteria?
I'm assuming some kind of projection should be applied.

I am using NHibernate 2 and Castle.ActiveRecord.

score 1 · Answer 1 · answered Apr 06 '11 at 11:50

1

If you have moved to NH3, then with QueryOver you can simply compare them:

session.QueryOver<Trip>().Where(c => c.ArrivalDate >= c.DepartureDate).List();

answered Apr 06 '11 at 11:50

Ilya Kogan

21,995
15
85
141

I still have NHibernate 2. Also, is that a part of the Linq provider? – the_drow Apr 06 '11 at 11:53

How to compare only the MM/dd/yyyy part of two dates with a detached criteria?

1 Answers1