Mongodb c # compare date without time

Question

How to compare date without time in mongodb c # driver?

I try to use this code, bot it does not work.

MongoCursor<Log> query = _logCollection.FindAs<Log>( Query.And(Query.EQ("Date.getDate()", date.Day), Query.EQ("Date.getMonth()", date.Month), Query.EQ("Date.getYear()", date.Year))); 

Do you have any ideas?

Answer 1

A request for a date range, including your date:

 var beginDate = date.Date; // eg 7/24/2013 00:00:00 var endDate = beginDate.AddDays(1); // eg 7/25/2013 00:00:00 var query = Query.And(Query<Log>.GTE(l => l.Date, beginDate), // including Query<Log>.LT(l => l.Date, endDate)); // not including var result = _logCollection.FindAs<Log>(query); 

Same thing with LINQ (MongoDB.Driver.Linq namespace):

 var result = from l in _logCollection.AsQueryable() where l.Date >= beginDate && l.Date < endDate select l;