tags:

views:

434

answers:

3
+1  Q: 

DateTime Comparison in LINQ

I am ran into the following issue.

Take a look at the following where clause.

Where(x => x.CreateTS <= dateParameters.CreationDate.ToDateValue &&
           x.CreateTS >= dateParameters.CreationDate.FromDateValue)

CreateTS is a Timestamp column in the table. so when my dateparameters are todate = 01/28/2010 12:00A.M" fromdate= "01/26/2010 12.00A.M" (c# DateTime types) my query doesnot retrivies the table records whose CreateTS look like 01/28/2010 1:45A.M and above just differeing in the timestamps.

I just wanted to do comparison and dont want to compare the timestamps. any help would be appreciated.

+2  A: 
Reed Copsey  2010-02-05 19:06:51
When I compare using the date portion I dont get any results and I am gettign the following error messageThe specified type member 'Date' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported.Any comments?
SARAVAN  2010-02-05 19:14:01
You didn't specify Entity Framework, so I was just using standard LINQ to Objects. See my revision for another option.
Reed Copsey  2010-02-05 19:21:02
Sorry my question was not clear earlier. But when I use AddDaysT am gettign the following error message The specified type member 'AddDays()' is not supported in LINQ to Entities. Only initializers, entity members, and entity navigation properties are supported
SARAVAN  2010-02-05 19:37:49
Reed Copsey  2010-02-05 19:43:45
A: 

I think this webpage may help you

http://www.bennadel.com/blog/122-Getting-Only-the-Date-Part-of-a-Date-Time-Stamp-in-SQL-Server.htm

Justen  2010-02-05 19:11:28
A: 

Interesting moment here is that 01/28/2010 12:00A.M actually in 24 hour format is 00:00 while 01/28/2010 1:45A.M is 01:45 and that seems to be the reason why those records are not returned. The midday will be 01/28/2010 12:00P.M

dh  2010-02-05 19:28:11

related questions

Handling and storing elapsed time
How do I convert local time to UTC in Python?
Mono's DateTime Serialization
Best practices for DateTime serialization in .Net framework 3.5/SQL Server 2008
Parsing exact dates in C# shouldn't force you to create an IFormatProvider
C# Casting vs. Parse
.NET Date Const (with Globalization)
Dynamic regex for date time formats
What is the simplest way to find the difference between 2 times in python?
Best way to convert DateTime to "n Hours Ago" in SQL
What's a good way to overwrite DateTime.Now during testing?
Datetime arithmetic with a string in Ruby
How can I get the DateTime for the Start of the Week?
Is DateTime.Now the best way to measure a function's performance?
SQL Server DateTime conversion failure
Natural language date/time parser for .NET?
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Why does this python date/time conversion seem wrong?
Dealing with PHP server and MySQL server in different time zones
How do I parse and convert DateTime's to the RFC 3339 date-time format?
HOWTO - Compare a date string to datetime in SQL Server?
Best method for varchar date validation in Sybase (T-SQL)?
What's the BEST way to remove the time portion of a datetime value (SQL Server)
How do I calculate relative time?
How do I calculate someone's age in C#?