SQL history query

Question

I am in need of a help with SQL. I need to do a query that returns a history of the current date up to 7 days behind. Could someone please help me?

Answer 1

If you want to search from the current date, you do not need to enter any date variable. Mysql is smart :), and is able to account for when it is seven days in the past.

Do so:

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

BETWEEN returns what is 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 data works like this:

SELECT GETDATE()

Current Date less 7 days:

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