Date Formats Mismatch Between Different Servers (xml Column)

I am facing a problem for past two days with regard to the date format in SQL. I have developed a application in ASP.NET and have deployed it in production server. I am persisting

Solution 1:

Try add the following to the web.config of your website:

<system.web><globalizationculture="en-ZA"uiCulture="en-ZA"/></system.web>

Replace "en-ZA" with the specific culture you require. The will ensure that the browsers culture settings will not be used.