ADD 1 SEC to date in a column of table

Question

using sql server 2008

i have date something like this,

2016-05-11 13:17:41.410

can i remove millisecond and add 1 sec

will look like this.

2016-05-11 13:17:42

Answer 1

declare @dt datetime = '2016-05-11 13:17:41.410'

select  @dt, dateadd(MILLISECOND, 1000 - datepart(MILLISECOND, @dt), @dt)

Sign up