How to work with date in php?

Question

PHP

Hello, I have a betting site, but I just can't implement this thing:
In the database, the date has the following format 2015-09-12 18:46:36
I need to make statistics for a week, a month, three months.
Please help me to do this.

Answer 1

Why do you need a date in php?
SELECT * FROM table WHERE date > (now()-interval 3 month)
SELECT * FROM table WHERE date > (now()-interval 1 month)
SELECT * FROM table WHERE date > (now()-interval 1 week)