Hi. I'm using ADO.NET to retrieve data from SQL Server via stored
procedures. Lately I found the following problem:
There's a stored procedure that has a DateTime input parameter (say
statusDate). This parameter is passed from ADO.NET code as DateTime.
Inside stored procedure, there's a comparison of dates that looks like
"...WHERE createDate = statusDate". Here, "createDate" is a column of
datetime type. The application was deployed on number of different
servers and worked just fine. Except one specific server where this
comparison fails, although the dates seem equal. I suspect that this
might have something to do with Locale/Regional ...