title: Converting Nvarchar(MAX) to DATETIME Datatype SQL Server query
body: <p>I'm having issues converting a <code>NVARCHAR(MAX)</code> to a <code>DateTime</code> datatype. I have checked for nulls and empty spaces. I'm not really sure why it isn't converting. Is it maybe because of they way it has the data in there now. If anyone could tell me what I have to change for it to work. </p>
  
  <pre><code>DateStamp
  ------------------
  2015-10-1413:09:17
  2015-10-1413:09:17
  2015-10-1413:09:19
  2015-10-1413:09:22
  2015-10-1413:09:23
  2015-10-1413:09:27
  2015-10-1413:09:27
  </code></pre>
  
  <p><code>DateStamp</code> is the column as you can see. Is there spaces that have to be put in or is there something else I have to change?</p>