Create time slot range of 60 min in SQL Server

Hi makumbi,

Use DATEADD function.

SELECT DATEADD(MINUTE, 30, GETDATE()); // 30 MIN
SELECT DATEADD(MINUTE, 60, GETDATE()); // 60 MIN

The considered period is 08:00 - 08:30 / 08:30 -09:00 and so on.

so the values i wanted in the table should be time only as seen below

08:00

08:30

09:00

09:30

etc because i just want to pass the a value the the time in created in that interval

thanks  

Which interval?

Share your code or query.