title: Converting varchar(50) to datetime data type in SQL Server
body: <p>I'm trying to update varchar(50) field to datetime in SQL Server, tried couple of ways but no success.</p>
  
  <p>I ways get error</p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character
    string.</p>
  </blockquote>
  
  <p>Here is sample values in the OrderDateTime column:</p>
  
  <pre><code>2014-05-21 04:21:45.3346898
  2014-02-26 08:43:58.5693805
  2014-04-29 15:57:21.0778236
  2014-04-09 07:23:57.3886545
  2014-03-14 16:03:46.3919145
  :::::::::::::::::::::::::::
  </code></pre>
  
  <p>Please help me either to identify that row causing issue or let me know if any force convert to datetime way available.</p>
  
  <p>I tried these:</p>
  
  <pre><code>UPDATE  Orders SET OrderDateTime=CONVERT(datetime, OrderDateTime)
  UPDATE  Orders SET OrderDateTime=CAST(OrderDateTime AS datetime)
  </code></pre>