title: Convert NVARCHAR to DATETIME in SQL Server 2008
body: <p>In my table</p>
  
  <pre><code>LoginDate  
  2013-08-29 13:55:48  
  </code></pre>
  
  <p>The <code>loginDate</code> column's datatype is <code>nvarchar(150)</code>  </p>
  
  <p>I want to convert the <code>logindate</code> column into date time format using SQL command  </p>
  
  <p>Expected result. </p>
  
  <pre><code>LoginDate  
  29-08-2013 13:55:48
  </code></pre>