title: Rounding milliseconds in T-SQL
body: <p>In <code>SQL Server 2008</code>, I have the below column of type <code>DateTime</code> in a table.</p>
  
  <pre><code>+-------------------------+
  | LTime                   |
  +-------------------------+
  | 2009-12-07 10:40:21.893 |
  | 2009-12-07 10:42:18.173 |
  +-------------------------+
  </code></pre>
  
  <p>From the above column, I want to select the <code>datetime</code> and round off the <code>milliseconds</code>, in order to get the below output</p>
  
  <pre><code>+---------------------+
  | LTime               |
  +---------------------+
  | 2009-12-07 10:40:22 |
  | 2009-12-07 10:42:18 |
  +---------------------+
  </code></pre>
  
  <p>Greatly appreciate your help in advance.</p>