title: SQL Server: Add seconds to a datetime field?
body: <p>This should be a softball for you SQL guys. I know I can add to an int field with something like <code>UPDATE tblUser SET Total=(Total+2)</code> but what is the syntax for adding seconds to a datetime field?</p>
  
  <p>I'm using SQLServer 2008</p>