[RESOLVED] Perform task based on datestamp

[zzz]

I need to run a script and expire some posts if they are older then 30 day.

I think i acn get an interval of the 30 days

WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY)

but I need to locate the items OLDER then 30 day. i think I'm pretty close, but a bit at a loss.

[zzz]

I think I got it

where POST_DATE < (CURDATE() - INTERVAL 30 DAY)