title: Cast As Time Remove Trailing Zeros
body: <p>I have a datetime field in Mssql. I am attempting to cast this to just time, but the result ends up with seven trailing zeros. I would like to just have the time, without the extraneous zeros. Here is my query with the result set. </p>
  
  <pre><code>SELECT cast(begin_time as time) AS begin_time FROM mytable;
  </code></pre>
  
  <p>Here is the result set: </p>
  
  <pre><code>08:08:31.0000000
  </code></pre>