Webmaster2020.com

Posted: **Fri Feb 26, 2016 12:49 pm**

Hi,

How do I make a query to get everything from 1 month ago until now?

thanks.

Posted: **Fri Feb 26, 2016 1:12 pm**

You can add some special functions,
but they depend on what type of Database Management System (DBMS) you use.
For mysql:

SELECT * FROM table WHERE datefield > DATE_SUB(NOW(), INTERVAL 1 MONTH);

for SQL server:

SELECT * FROM table WHERE datefield > DATEADD(m, -1, GETDATE());

Not sure how it is in PostgreSQL and oracle,
but I'm sure it something similar.

SQL-query everything from last month