Create time slot range of 60 min in SQL Server

makumbi

SOLVED CLOSED ACTIVE ANSWERED
User: makumbi
Posted: on Jan 30, 2024 10:39 AM
Forum: SQL Server
Replies: 3
Views: 787

Please help how can i create a time slot with slots of range of either 30min range or 60min passed as a parameter and saved in my sqlserver table. the time ranges should be saved in the table thanks

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 1

Reply
User: dharmendr
Replied: on Jan 30, 2024 10:42 AM
Report

Hi makumbi,

Use DATEADD function.

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Create time slot range of 60 min in SQL Server

Company

Explore

Follow us

Contact Us