Getting the next 6 days records

Please go through below SQL query:

CREATE TABLE dbo.Duration

(

startDate datetime2

,endDate datetime2

);

INSERT INTO dbo.Duration(startDate,endDate)

VALUES('2007-05-06 12:10:09','2007-05-07 12:10:09');

INSERT INTO dbo.Duration(startDate,endDate)

VALUES('2007-05-11 12:10:09','2007-05-20 12:10:09');

INSERT INTO dbo.Duration(startDate,endDate)

VALUES('2007-05-10 12:10:09','2007-05-15 12:10:09');

SELECT *

FROM dbo.Duration

WHERE DATEDIFF(day, startDate, endDate) <= 6;

Output:

startDate endDate

--------------- -------------------

2007-05-06 12:10:09.0000000 2007-05-07 12:10:09.0000000

2007-05-10 12:10:09.0000000 2007-05-15 12:10:09.0000000

1 Reply

Know the answer? Post it — somebody with the same question will find it here.