How to Write a Query to Get Data from the Last 7 Days in SQL Server?

Question

Ravi Vishwakarma · Answer

To retrieve data from the last 7 days in SQL Server, you can use the GETDATE() function along with the DATEADD() function to filter the rows.

Here's a simple example of how to achieve this:

Assume you have a table named Users with a column CreationDate that stores the date and time when each order was placed.

Query to Get Data from the Last 7 Days

SELECT *
FROM Users
WHERE CreationDate >= DATEADD(day, -7, GETDATE());

Explanation

GETDATE(): This function returns the current date and time.
DATEADD(day, -7, GETDATE()): This function subtracts 7 days from the current date and time. It essentially calculates the date and time exactly 7 days ago.
OrderDate >= DATEADD(day, -7, GETDATE()): This condition filters the rows to include only those where the CreationDate is within the last 7 days.

forum