I tried using below query but it did not worked,please suggest
Code: Select all
SELECT count(slots) FROM acctn
WHERE (DATEPART(mm, start_time) = 00 AND (DATEPART(ss, start_time) = 00
output should be like:
Date count
2016-01-01 00:00:00 value
2016-01-01 01:00:00 value