title: String conversion to DATETIME in SQL Server
body: <p>I need to convert a string to <code>datetime</code>. I need to store <code>datetime</code> with milliseconds in SQL Server 2005.</p>
  
  <p>example: </p>
  
  <pre><code>SELECT CAST('2010-07-28 20:07:25.733000000' AS DATETIME)
  </code></pre>
  
  <p>when I try I am getting error like </p>
  
  <blockquote>
    <p>Conversion failed when converting datetime from character string</p>
  </blockquote>