select a date....

[cho@]

Hi
i'd like to delete all the data in a table which are stored since more dan one month....

DELETE FROM table WHERE datefiled > NOW()+ one month.....

is it possible to do like dat.....

how do i had a month to NOW().....
i use a Mysql database...

thanks for ur help

bye

[vvlad]

Hi
I think you should try this
DELETE FROM table WHERE TO_DAYS(datefiled) < TO_DAYS(NOW())-30