title: Truncate Datetime to Second (Remove Milliseconds) in T-SQL
body: <p>What is the best way to shorten a  datetime that includes milliseconds to only have the second?</p>
  
  <p>For example <code>2012-01-25 17:24:05.784</code> to <code>2012-01-25 17:24:05</code></p>