title: TSQL Convert VARCHAR of HHMMSS to TIME
body: <p>I have a VARCHAR field that has sample values as listed below and I would like to convert it to HH:MM:SS. Suggestions?</p>
  
  <pre><code>151200
  085800
  080100
  210100
  083300
  </code></pre>