How to Extract the Last 7 Days of Data From a SQL Server Table?

Extracting Last 7 Days' Data in SQL Server: A SQL Query Resolution

In database management systems, retrieving data within a specific time range is a common requirement. This question addresses a specific need for obtaining the last 7 days' worth of data from a SQL Server table, known as "A," to be loaded into a MySQL table.

The key to this query lies in the understanding that timestamps and date formats can vary between databases. In the given scenario, the "CreatedDate" column in the SQL Server table is a datetime data type, while the "created_on" column in the MySQL table is a timestamp data type.

The original query provided in the question retrieves data between "GETDATE()-7" and "GETDATE()." However, initial testing revealed that it was only returning 5 days' worth of data.

The solution lies in utilizing the DATEADD function to adjust the date range appropriately. The final query, as depicted below:

<code class="sql">SELECT id, NewsHeadline as news_headline, NewsText as news_text, state CreatedDate as created_on
FROM News 
WHERE CreatedDate >= DATEADD(day,-7, GETDATE())</code>

This revised query uses DATEADD to subtract 7 days from the current date ("GETDATE()"), resulting in the starting date of the 7-day range. The result is a query that effectively extracts the last 7 days' data from the "News" table, aligning with the requirement of loading this data into the MySQL table with a timestamp data type in the "created_on" column.

The above is the detailed content of How to Extract the Last 7 Days of Data From a SQL Server Table?. For more information, please follow other related articles on the PHP Chinese website!