C# datetime compare to sql server datetime

Question

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?

Sreejesh SP · 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

Jignesh Trivedi · Answer

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

Vulpes · Answer

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 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.