SQL query.

[doctor_james]

Hi .

How can I get those records which are older less than a month ?

thanks in advance.

[toplay]

Your "older less" seems contradictory. Below, I'm assuming you want rows that are older than a month ago based on a date_column of type DATE (not DATETIME).

 

SELECT * FROM table_name WHERE date_column < DATE_SUB(CURDATE(), INTERVAL 1 MONTH)

 

See manual:

http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html#function_date-sub

 

Sometime you'll see people post just the ' - INTERVAL 1 MONTH', but that only works with certain versions of MySQL, so my example uses the DATE_SUB() function since I don't know the version of your MySQL.

[fenway]

Sometime you'll see people post just the ' - INTERVAL 1 MONTH', but that only works with certain versions of MySQL, so my example uses the DATE_SUB() function since I don't know the version of your MySQL.

This "date arithmetic" functionality was added in v3.23 -- I seriously hope no one is using anything prior to that release (or that release, for that matter).  So it's quite safe to use; and IMHO much easier to read without extra parens.