SQL History Query

If you want to fetch from the current date, you do not need to enter any date variables. MySQL is smart :), and is able to make the count of when it's seven days in the past.

Do this:

SELECT * 
FROM tabela 
WHERE 
  data BETWEEN CURRENT_DATE()-7 AND CURRENT_DATE()  

BETWEEN returns what's between these dates.

CURRENT_DATE() returns the current date.

CURRENT_DATE()-7 returns the current date minus seven days.

References:

• MySQL Comparison Functions and Operators
• MySQL Date and Time Functions

In SQL Server the function for date works like this:

SELECT GETDATE()

Current date at 7 days:

SELECT DATEADD(dd, -7, GETDATE())