Hello all. I have a few questions that I hope you can help me out on.

I have a table called 'transaction' on a MYSQL database. Within this table there is a field called 'SettlementDate' the format of the date is in 0101, 0102, 0103 (Jan 1, Jan 2, Jan 3) format. I need to create a cronjob to delete all data in 'transaction' older than three months.

Currently, I have

delete *
from transaction
where SettlementDate > '3 month'

and it returns an empty field.

I'm a little stuck and I'd appreciate some help.

For the cronjob I was going to do:

--------------------------------------------------------------------

mysql --user=+++++++ --password=+++++++
use +++++++
delete * from transaction where SettlementDate > '3 month';

--------------------------------------------------------------------

Thanks!