C# datetime compare to sql server datetime

13y13.2kVisual Basic .NET

In a C# 2010 desktop application I am using a linq to sql statement to compare a C# datetime field to a sql server 2008 r2 datetime field. By doing this comparison I am getting inconsistent results. Thus I am guessing a C# datetime field is not the same as a sql server 2008 r2 datetime value.

Thus for this comparison to work, I would like to know how to change a C# datetime field to a sql server date time field. I would think I would need to do this conversion prior to comparing the dates.

I want to compare to see if sql date > minimum date (1/1/1753) and sql date < current today's date. Can you tell me how to write this comparision?

Thus now you show me code and/or point me to a reference that will show me how to solve this problem?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sreejesh SP13y ago
Accepted answer
Dear

sql date format is YYYY-MM-DD and c# date format is DD-MM-YYYY,

so pls change sql date or c# date format, my decision is pls change sql date format,

pls split sql date and change first and and third then compare ,

Thanks

Sreejesh
0
Jignesh Trivedi13y ago
hi,

Please refer below link it might help you.

http://weblogs.asp.net/zeeshanhirani/archive/2008/08/22/comparing-dates-in-linq-to-sql.aspx
0
Vulpes13y ago
To make sure that your C# DateTime value is within the range of the SQL Server datetime type, you can use this code:

DateTime dt = DateTime.MinValue; // or whatever
DateTime min = new DateTime(1753, 1, 1);
if (dt < min) dt = min;

So, if your C# DateTime is before midnight on 1/1/1753, this will set it to that minimum date.

There is no problem with the upper limits which are the same for both types.
0