title: Convert Time in SQL not to have millisecond
body: <p>I have a <code>datetime</code> column in my table but I need to separate it into date and time so here's what I've done so far.</p>
  
  <pre><code>CONVERT(VARCHAR(10), [timeStamp], 103) AS date, CONVERT(TIME, [timestamp]) AS time
  </code></pre>
  
  <p>But the problem is, I'm having milliseconds in the time column (eg. 23:39:55.0000000) so how can I do to have just hour:minute:second only?</p>