Re: Datetime ranges

[Joao Prado Maia]

Hi,

You can use the DATE_SUB() function with the INTERVAL clause. From the manual:

http://dev.mysql.com/doc/mysql/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 DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= date_col;
----

Hope that helps.

Cheers,
Joao Prado Maia
MySQL AB