SQl Server: Add seconds to a datetime field?

Question

This should be a softball for you SQL guys. I know I can add to an int field with something like "UPDATE tblUser SET Total=(Total+2)" but what is the syntax for adding seconds to a datetime field?

I'm using SQLServer 2008

Answer 1

UPDATE tbluser SET DateField = DATEADD(ss,numOfSeconds,DateField)

Note the first parameter "ss". This shows that you are adding seconds to the date.

Check the docs for more info.

Answer 2

You should look into DATEADD.

DATEADD (datepart , number , date)

or the full update syntax

UPDATE tbl SET YourDateField = DATEADD (ss, 2, YourDateField)