title: How to convert nvarchar type to only time type format in sql server
body: <p>I have a column of type <code>nvarchar</code> i.e <code>170948</code> I want to store it in time type column</p>
  
  <p>For that I had written </p>
  
  <pre><code>select @CurrentTimeValue=Convert(time, items, 108) from T
  </code></pre>
  
  <p>but it is throwing error </p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>Please suggest the correct format</p>