query to calculate end time

Question

Hello... i need help in doing query to retrieve data at certain time. i have certain date eg : 31/1/2021 the start time is current time on that date, let say 8am. i want the data retrieve is in range between start time(8am) and 150 minute after the start time. Please help anybody. TQ.

Amira Bedhiafi · Answer

SELECT * FROM Mytab WHERE DateCol > GETDATE() and DateCol minute ,150,GETDATE() Check DBFiddle : https://dbfiddle.uk/?rdbms=sqlserver_2019&fiddle=6599cdac2ec7d02243587914c1350962

Rijwan Ansari · Answer

You can create Stored Procedures with Parameters Currentdate and duration to get data with secific time intervals. Example: CREATE PROCEDURE SPQueryName @CurrentDate datetime , @Duration int AS SELECT * FROM TableName WHERE CreatedOnUtc > @CurrentDate and CreatedOnUtc minute ,@Duration,@CurrentDate) GO; DATEADD is used for date + duration DATEADD( minute ,@increase,@InputDate) And you can execute query with current and duration. Additionally you can use SYSDATETIME() for system current datetime. Regards Rijwan

Sachin Singh · Answer

create a job Put your query into stored procedure, Create a job that will check the date and time and launch the SP Set interval for Job

Asma Khalid · Answer

You can create a store procedure as follow i.e. CREATE PROCEDURE [dbo].[sp_get_schedule_data] AS BEGIN DECLARE @startTime nvarchar( max ) DECLARE @endTime nvarchar( max ) SET @startTime = GETDATE() SET @endTime = DATEADD( MINUTE , 150, @startTime) SELECT * FROM MyTable WHERE MyTable.CreatedDatetime >= @startTime AND MyTable.CreatedDatetime END Create windows service of particular schedule and call this procedure to get/send data accordingly.