SQL Server: Add seconds to a datetime field?

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.