Using SQL Server Date datatype and C# DateTime to select records

Question

I have an ActionResult where I want to select records based on a date column in SQL Server. This date is in a column of type Date. I can't directly compare the dates since C# DateTime includes the time component and the Date datatype does not. Is there a nice way to do this?

public ActionResult AbsencesByDate(DateTime date)
{
        var absences = from attendance in db.Attendances
                          where attendance.Date == date
                          select new
                          {
                              returnedPersonID = attendance.PersonID,
                             FullName = attendance.Person.FName + " " + attendance.Person.LName,
                          };
        return Json(absences, JsonRequestBehavior.AllowGet);
}

Joel Gauvreau · Accepted Answer · 2013-11-11 16:42:52Z

2

You could remove the time part from your date parameter in your function. Something like this :

public ActionResult AbsencesByDate(DateTime date)
{
    date = date.Date;
    var absences = from attendance in db.Attendances
                      where attendance.Date == date
                      select new
                      {
                          returnedPersonID = attendance.PersonID,
                         FullName = attendance.Person.FName + " " + attendance.Person.LName,
                      };
    return Json(absences, JsonRequestBehavior.AllowGet);
}

answered Nov 11, 2013 at 16:42

Joel Gauvreau

3,6564 gold badges32 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

user2979980 · Accepted Answer · 2013-11-11 16:54:29Z

1

try using:

where attendance.Date == date.Date

answered Nov 11, 2013 at 16:54

user2979980

363 bronze badges

1 Comment

forwheeler Over a year ago

I think this is the easiest solution so I went with this.

Collectives™ on Stack Overflow

Using SQL Server Date datatype and C# DateTime to select records

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related