date question

[jake66]

Hi,

I would like to know if it is possible and how to set (in a query) a function to retrieve all the records where date is anywhere from today up to one month ahead.
I can do queries I am just interested in this function.

Thanks in advance,
Jake

(maybe this should be in MySQL - I am not sure - sorry if it should :P )

[KuriosJon]

select * from table where your_date_column < date_add(your_date_column, interval 1 month)

mysql date_add()

[jake66]

thanks

[Fou-Lu]

You may want to use a BETWEEN to pull the CURDATE() as well. The above code will pull all records up to a month from today, but also from anything in the past.
Moving to MySQL forum.