title: SQL Server String Parsing
body: <p>I have SQL Server 2005 and all dates are stored using a DATETIME column type. The front-end application handles dates in a "yyyyMMdd hhmmss" format.  I'm writing a set of SQL queries and stored procedures and was wondering if there is an easy way to convert this format to the standard SQL DATETIME.  I did not code the front-end app so I cannot make any changes to it.</p>
  
  <p>I have looked into CONVERT(), but none of the type codes match what I want.  The closest one is </p>
  
  <pre><code>CONVERT(DATETIME, '20101017' 112)
  </code></pre>
  
  <p>But that does not have the time component of the input.  Any ideas?  or do I have to write a SQL function to do that parsing and conversion.</p>
  
  <p>Thank you,</p>