Hent fra db hvor timestamp er max 30 dage gammel

MySQL: WHERE dato >= now()-30

sone: Tror kun det giver dig 30 sekunder...

Direkte gaflet fra: http://www.mysql.com/doc/en/Date_and_time_functions.html

Here is an example that uses date functions. The following query selects all records with a date_col value from within the last 30 days:

mysql> SELECT something FROM tbl_name
          WHERE TO_DAYS(NOW()) - TO_DAYS(date_col) <= 30;

jeg siger tak, og har bogmærket linket til næste gang!