title: CAST nvarchar to DATETIME
body: <p>I've recently imported some spatial data into SQL 2008 from SDF.  During the import process, DateTime fields were imported as nvarchar(254).  An example of how the data was imported is this: <code>'20130515103000'</code></p>
  
  <p>In setting up my view, I used <code>SELECT CAST(survey_date AS DATETIME) AS Expr1</code> and have the following Error: </p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>From what I can tell, it looks like I may need to reformat my data to conform to the ISO-8601 format before casting or converting the data.  I'm not sure how to go about doing this.  </p>