title: convert nvarchar to smalldatetime in sql server
body: <p>I have one table in which <code>nvarchar</code> data are there.</p>
  
  <pre><code>Table
  18-FEB-11 10.29.52.000000000 AM
  20-FEB-11 04.10.40.000000000 PM
  23-SEP-10 10.34.57.714000000 AM
  08-OCT-10 09.41.16.921000000 PM
  </code></pre>
  
  <p>I want to convert this field to small date time in sql server 2008 R2</p>
  
  <p>How can i convert it.</p>
  
  <pre><code>Expected OUTPUT:
  
  2011-02-18 10:29:52
  2011-02-20 16:10:40
  2010-09-23 10:34:57
  2010-10-08 21:41:16
  </code></pre>