selecting information by date in mysql

trscookie · 07-19-2006, 08:16 AM

hello all,

i want to be able to select all the information that is in on of my tables that is over six months old in mysql, how can i do this?

the table has a date column with the date that it was created called createdOn. cheers trscookie

taylor_venable · 07-19-2006, 08:52 AM

I believe you can simply use the where clause of a select statement like this:

Code:

select * from table where createdOn >= start and createdOn < end

where table is the name of the table, and start and end are the date ranges of the selection in the form "YYYYMMDD" e.g. "20060719".

smallville · 07-20-2006, 09:28 PM

use interval

select * from tablename where datecol <= curdate() - interval 6 month

paulsm4 · 07-20-2006, 09:53 PM

smallville is correct.

But I think on older versions of mysql, you might have to use syntax like:

Quote:

DATE_SUB(NOW(), INTERVAL 1 MONTH);

trscookie · 07-21-2006, 05:07 AM

thank you.