title: convert string to datetime in sql server
body: <p>I have a column of dates with no delimiters. The column is nvarchar. The strings are consistent in length and format of <code>MMDDYYYY</code>. How can I convert these values to <code>datetime</code>?</p>
  
  <p>edit - this question is in reference to sql server.</p>