using sql server 2008 i have date something like this,
2016-05-11 13:17:41.410
2016-05-11 13:17:42
declare @dt datetime = '2016-05-11 13:17:41.410' select @dt, dateadd(MILLISECOND, 1000 - datepart(MILLISECOND, @dt), @dt)