Rolling 7-day window in PostgreSQL

Question

Accepted Answer

CURRENT_DATE - INTERVAL '7 days' computes the date 7 days before today. The >= operator then keeps all rows on or after that date. DATEADD and DATEDIFF are SQL Server / MySQL functions - not valid PostgreSQL. This pattern (CURRENT_DATE - INTERVAL) is the standard PostgreSQL idiom for rolling date filters.