TrackId StartTime EndTime 1 2014-10-16 05:48:17 2014-10-16 05:52:25 2 2014-10-16 05:49:17 2014-10-16 05:52:25 1 2014-10-16 05:49:17 2014-10-16 05:52:25 1 2014-10-17 10:49:17 2014-10-16 10:51:25
Time Count 2014-10-16 05:49:00 1 2014-10-16 05:50:00 3 2014-10-16 05:51:00 3 2014-10-16 05:52:00 3 2014-10-17 10:50:00 1 2014-10-17 10:51:00 1
declare @dt datetime set @dt = '09-22-2007 15:07:38.850' select dateadd(mi, datediff(mi, 0, dateadd(s, 30, @dt)), 0)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)