On the first server ODBC – dates pulled incorrectly 3/29/2010 12:00:00 AM SQL connection – dates pulled correctly 2010-03-29 00:00:00.000 On the second server both ODBC and SQL connection pull dates correctly 2010-03-29 00:00:00.000. What's wrong with the first server's ODBC settings, why date is pulled in the wrong format?

What tools or applications are doing the interpretation? Also why does it matter? Regards, Dave Patrick .... Microsoft Certified Professional -Microsoft MVP [Windows]

Hi, As the issue is more related to SQL Server, I would like to suggest that you initiate a new thread in our official SQL Server, forum for better and accurate answer to the question. The community members and support professionals there are more familiar with SQL Server, and can help you in a more efficient way. http://social.technet.microsoft.com/Forums/en-US/category/sqlserver Regards, Wilson JiaThis posting is provided "AS IS" with no warranties, and confers no rights.