Limit MySQL Results to X Days

Question

I have a field in my table called date and it stores via the NOW() function the date the entry was added.

I need to query the database to find entries within the last 30 days only.

Is this possible in a single query?

Q: http://stackoverflow.com/q/13997176/1415724 and A: http://stackoverflow.com/a/13997357/1415724 and http://stackoverflow.com/a/14799618/1415724 as found under **"Related" >>>** — Funk Forty Niner, Nov 02 '13 at 23:34
Or http://stackoverflow.com/questions/9616869/get-from-database-but-only-last-30-days — Reeno, Nov 02 '13 at 23:36
Another duplicate here: [MySQL Query - Records between Today and Last 30 Days](http://stackoverflow.com/q/2041575/367456) — hakre, Nov 03 '13 at 12:16

score 1 · Accepted Answer · answered Nov 02 '13 at 23:49

1

Sure. Create a time window and you can limit by that date

$time = time() - (86400 * 30); // 86400 seconds in one day
$sql = 'SELECT * FROM table WHERE datefield > "' . date('Y-m-d H:i:s', $time) . '"';

That should yield you records within the last 30 days

answered Nov 02 '13 at 23:49

Machavity

why not use the built in mysql functions? – Nov 03 '13 at 00:09
I've always shifted my processing to PHP because the database tends to be the choke point in processing. If this is just a one-off thing it probably doesn't matter. But feel free to post the MySQL answer – Machavity Nov 03 '13 at 00:24

1 Answers1