title: time format on my sql server
body: <p>my c# program selects a datetime field from database and returns the data like the following:</p>
  
  <pre><code>21/06/2012 4:11:48 p.m.
  </code></pre>
  
  <p>it is not stored this way though (it's stored like 2012/06/21 15:19:10:000).
  my locale is set to English/New Zealand</p>
  
  <p>but when I try to save it back to database </p>
  
  <p>the <code>ISDATE()</code> sql function doesn't like that format and just returns NULL. Do I have any options to set the time format in sql or c#? What in sql or c# is making it put "p.m."? (instead of just "PM", which by the way works)</p>
  
  <p><strong>Summing up the problem</strong></p>
  
  <p><a href="https://stackoverflow.com/q/11144907/139698">See latest related link</a></p>