display result from last 7 days

[aprinc]

I have field in database where date of posting is stored, but what is a query for displaying result from last 7 days or last month.

Thanks Adi

[Wien]

Last 10 days :

SELECT ... FROM ... WHERE ((to_days(now())-10) < to_days(MyFieldDate));

[[deleted]]

Or use date_sub, which is much less work for the database.