title: How do you update a DateTime field in T-SQL?
body: <p>The following query does not update the datetime field:</p>
  
  <pre><code>update table
  SET EndDate = '2009-05-25'
  WHERE Id = 1
  </code></pre>
  
  <p>I also tried it with no dashes, but that does not work either.</p>