Getting the next 6 days records

Question

How can i write a database view that gets only todays and the next 6 days records? thank you in advance

Manas Mohapatra · Answer

Please go through below SQL query: CREATE TABLE dbo.Duration ( startDate datetime2 endDate datetime2 ); INSERT INTO dbo.Duration(startDateendDate) VALUES('2007-05-06 12:10:09''2007-05-07 12:10:09'); INSERT INTO dbo.Duration(startDateendDate) VALUES('2007-05-11 12:10:09''2007-05-20 12:10:09'); INSERT INTO dbo.Duration(startDateendDate) VALUES('2007-05-10 12:10:09''2007-05-15 12:10:09'); SELECT * FROM dbo.Duration WHERE DATEDIFF(day startDate endDate) 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