DateTime criteria without timestamp

Otake · **Joined:** Fri Jul 25, 2008 4:48 am **Posts:** 2

Hi,

I have a datetime column in SQL server and I need to give a criteria to this column but without the timestamp.

As an example lets say I have orders with OrderDate in the database and this column also contains the time of the orders not only the dd/mm/yyyy part; but I want to retrieve the orders according to dd/mm/yyyy part.

Is there anyway to do this in Nhibernate?

Otake

wolli · **Posted:** Tue Jul 29, 2008 2:15 am

Try this:

Code:

crit.Add(Expression.Between("OrderDate", orderDate.Date, orderDate.AddDays(1).Date))

;

Otake · **Joined:** Fri Jul 25, 2008 4:48 am **Posts:** 2

Hi,

Thanks for the reply. I have done something similiar:

criteria.Add(Expression.Ge("StartTime", date.Date));
criteria.Add(Expression.Lt("StartTime", date.Date.AddDays(1)));

I think this better then above because if your date is '28/07/2008', this does not include '29/07/2008 00:00:0000' as your criteria does.

Otake