Linq where clause compare only date value without time value

Question

var  My ResetSet Array    DB      tbl MyTable      Where x   gt  x Active    true          amp  amp  x DateTimeValueColumn  lt   DateTime Now       Select x   gt  x     Upper query is working correct   But I want to check only date value only  But upper query check date   time value   In traditional mssql  I could write query like below   SELECT   FROM dbo tbl MyTable WHERE  CAST CONVERT CHAR 10   DateTimeValueColumn  102  AS DATE   lt                CAST CONVERT CHAR 10  GETDATE   102  AS DATE  AND Active   1   So could anyone give me suggestion how could I check only date value in Linq

User · Answer

amp  amp  x DateTimeValueColumn  lt   DateTime Now   This is supported so long as your schema is correct   amp  amp  x DateTimeValueColumn Value Date  lt  DateTime Now

User · Answer

EDIT  To avoid this error   The specified type member  Date  is not supported in LINQ to  Entities  Only initializers  entity members  and entity navigation properties are  supported   var  My ResetSet Array    DB                  tbl MyTable                  Where x   gt  x Active    true                            Select x   gt  x  ToList      var filterdata    My ResetSet Array          Where x  gt DateTime Compare x DateTimeValueColumn Date  DateTime Now Date    lt   0      The second line is required because LINQ to Entity is not able to convert date property to sql query  So its better to first fetch the data and then apply the date filter   EDIT  If you just want to compare the date value of the date time than make use of   DateTime Date Property - Gets the date component of this instance   Code for you   var  My ResetSet Array    DB                  tbl MyTable                  Where x   gt  x Active    true       amp  amp  DateTime Compare x DateTimeValueColumn Date  DateTime Now Date    lt   0                             Select x   gt  x       If its like that then use  DateTime Compare Method - Compares two instances of DateTime and returns an integer that indicates whether the first instance is earlier than  the same as  or later than the second instance   Code for you   var  My ResetSet Array    DB                  tbl MyTable                  Where x   gt  x Active    true                    amp  amp  DateTime Compare x DateTimeValueColumn  DateTime Now    lt   0                             Select x   gt  x     Example   DateTime date1   new DateTime 2009  8  1  0  0  0   DateTime date2   new DateTime 2009  8  1  12  0  0   int result   DateTime Compare date1  date2   string relationship   if  result  lt  0     relationship    is earlier than   else if  result    0     relationship    is the same time as            else    relationship    is later than

User · Answer

Use mydate Date to work with the date part of the DateTime class only

User · Answer

In similar case I used the following code   DateTime upperBound   DateTime Today AddDays 1      If today is October 9  then upperBound is set to 2012-10-10 00 00 00 return var  My ResetSet Array    DB      tbl MyTable      Where x   gt  x Active    true          amp  amp  x DateTimeValueColumn  lt  upperBound     Accepts all dates earlier than October 10  time of day doesn t matter here      Select x   gt  x

User · Answer

result   from r in result where  r Reserchflag    true  amp  amp        r ResearchDate Value Date  gt   FromDate Date  amp  amp        r ResearchDate Value Date  lt   ToDate Date   select r

User · Answer

Working code                   DataBaseEntity db   new DataBaseEntity       This is EF entity         string dateCheck  5 21 2018           var list  db tbl          where x  gt  x DOE Value Month                    x DOE Value Day                    x DOE Value Year                ToString                 Contains dateCheck

User · Answer

Simple workaround to this problem to compare date part only  var  My ResetSet Array    DB                      tbl MyTable                      Where x   gt  x Active    true  amp  amp                                  x DateTimeValueColumn Year    DateTime Now Year                              amp  amp  x DateTimeValueColumn Month    DateTime Now Month                              amp  amp  x DateTimeValueColumn Day    DateTime Now Day     Because  Date  datatype is not supported by linq to entity   where as Year  Month and Day are  int  datatypes and are supported

User · Answer

Do not simplify the code to avoid  linq translation error   The test consist between a date with time at 0 0 0 and the same date with time at 23 59 59          iFilter MyDate1   DateTime Today      or DateTime MinValue             GET          var tempQuery   ctx MyTable AsQueryable             if  iFilter MyDate1    DateTime MinValue                        TimeSpan temp24h   new TimeSpan 23 59 59               DateTime tempEndMyDate1   iFilter MyDate1 Add temp24h                   DO not change the code below  you need 2 date variables                tempQuery   tempQuery Where w   gt  w MyDate2  gt   iFilter MyDate1                                            amp  amp  w MyDate2  lt   tempEndMyDate1                      List lt MyTable gt  returnObject   tempQuery ToList

User · Answer

There is also EntityFunctions TruncateTime or DbFunctions TruncateTime in EF 6 0

User · Answer

Try this   var  My ResetSet Array    DB      tbl MyTable      Where x   gt  x Active    true           amp  amp  x DateTimeValueColumn  lt   DateTime Now       Select x   gt  x DateTimeValueColumn       AsEnumerable        select p  gt p DateTimeValueColumn value toString  YYYY-MMM-dd

[c#] Linq where clause compare only date value without time value

Examples related to c#

Examples related to entity-framework

Examples related to datetime

Examples related to linq-to-entities

Examples related to compare