title: Remove milliseconds from time datatype and also: is there a millisecond-less time datatype?
body: <p>I have seen posts in the question on how to remove milliseconds from the datetime datatype in MS SQL.</p>
  
  <p>But what about the time datatype - what is the easiest way to remove milliseconds from the time datatype?</p>
  
  <p>Also: Is there any time datatype in MS SQL (2008) that doesn't include milliseconds?</p>
  
  <p>Thanks all!</p>