title: Computed column date from nvarchar field
body: <p>I have a <code>nvarchar(50)</code> field (DateHr) that holds the date and time in the following format: <code>yy/mm/dd hh:mm:ss</code> (ex. <code>12/04/11 16:49:23</code> which should translate to <code>April 11, 2012 4:49 PM</code>). </p>
  
  <p>I am having a hard time trying to manage the date values in this format. </p>
  
  <p>I was wondering if I can create a column as a <code>DateTime</code> datatype and use this new field.</p>