Forum Discussion

Oded-Dror's avatar
Oded-Dror
Icon for Helper III rankHelper III
2 years ago

Time interval

Hi there, See image below. In the left I have SQL Server table called example with two ID's  And DTTM columns. I need it to capture 15 running min interval with reseting the loop (every 15 min set...
Need Help
Ahmedx's avatar
Ahmedx
Icon for Super User rankSuper User
2 years ago

Please check this '789','2017-10-05 10:32:00.000')
('789','2017-10-05 10:47:00.000'
does not fall within the 15 minute interval

 

Oded-Dror's avatar
Oded-Dror
Icon for Helper III rankHelper III
2 years ago

The running total is reseting every 15 min. where is 10:32 (10:32 - 10:12 = 20)