title: Saving Dates in SQLServer
body: <p>I have a legacy application where the input is a date string, i.e.:</p>
  
  <blockquote>
    <p>06/12/2009</p>
  </blockquote>
  
  <p>The format of the input is always a string, and is consistent, it's always dd/mm/yyyy</p>
  
  <p>At the moment the legacy app just INSERTS this in a DateTime fields. Obviously if the Localization Culture settings of the Server change, <strong>we have a bug</strong>.</p>
  
  <p>Two questions:</p>
  
  <p><em>One</em>:</p>
  
  <p><strong>Whats the safest way to store Dates in SQLServer in this situation?</strong></p>
  
  <p><strong>Is there a format that will always be correctly interpreted regardless of the order of day and month?</strong></p>
  
  <p><em>Two:</em></p>
  
  <p><strong>What settings exactly determines the culture of a SQLServer DB, is it an OS setting, or a setting of that DB, or what?</strong></p>
  
  <p>cheers</p>