forum

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

Ask Question
Ravi Vishwakarma

Ravi Vishwakarma

Follow
Ravi Vishwakarma is a dedicated Software Developer with a passion for crafting efficient and innovative solutions. With a keen eye for detail and years of experience, he excels in developing robust software systems that meet client needs. His expertise spans across multiple programming languages and technologies, making him a valuable asset in any software development project.

Can you answer this question?

Answer

1 Answers

Ravi Vishwakarma

Ravi Vishwakarma

16-Jul-2024

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

  1. GETDATE(): This function returns the current date and time.
  2. 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.
  3. OrderDate >= DATEADD(day, -7, GETDATE()): This condition filters the rows to include only those where the CreationDate is within the last 7 days.

 

Liked By