title: How to convert a column of nvarchar string in hh:mm:ss format into datatype of time permanently in a table?
body: <p>I want to convert a table column like</p>
  
  <p>Departure_time</p>
  
  <p>06:44:00        (&lt;- these are just <strong>NVARCHAR</strong> strings)</p>
  
  <p>06:45:00</p>
  
  <p>06:45:00</p>
  
  <p>06:46:00</p>
  
  <p>06:47:00</p>
  
  <p>06:47:00</p>
  
  <p>06:48:00</p>
  
  <p>06:49:00</p>
  
  <p>06:50:00</p>
  
  <p>06:50:00</p>
  
  <p>06:50:00</p>
  
  <p>06:51:00</p>
  
  <p>06:51:00</p>
  
  <p>06:52:00</p>
  
  <p>06:52:00</p>
  
  <p>(sorry guys I really do want to post a screen-shot here which would made the post looks way much better but it says I need a reputation of 10. So, I just make one table column)</p>
  
  <p>which in <strong>NVARCHAR</strong> datatype, into <strong>TIME</strong> type in MSSQL 2012?</p>
  
  <p>I tried Time(0) and Time(7) and all threw an error of </p>
  
  <p>"Conversion failed when converting date and/or time from character string."</p>
  
  <p>and I do want to change the type of that column of the table permanently. Not only select them and present them in the time format.</p>
  
  <p>So... anyone can help me on how to do this please?</p>
  
  <p>Thank you!</p>