title: Why does date format changes to month first in date time object?
body: <p>In a web application, I am passing datetime without formatting it in a XML response, just <code>item.Date</code> (<code>DateTime</code> datatype) is put in code. </p>
  
  <p>No formatting is done. When I run the local server it returns the date in <code>MM/DD/YYYY</code> format and in live environment <code>DD/MM/YYYY</code>. Why this change is happening?</p>
  
  <p>I checked on database collation and OS settings. Live environment had <code>English (Singapore)</code> in regional settings. However after changing local servers to <code>English (Singapore)</code> still live environment <code>DateTime</code> format is not being produced locally. </p>
  
  <p>Collation: </p>
  
  <pre><code>In Live Environment - Latin1_General_CI_AI
  In Local Servers    - SQL_Latin1_General_CP1_CI_AS
  </code></pre>
  
  <p>What could be the reason? how to resolve this rather than doing formatting in XML?</p>
  
  <blockquote>
    <p><strong>Update</strong></p>
  </blockquote>
  
  <p>As suspected, Issue is with collation, regenerated the issue locally after creating DB with collation in live environment. </p>