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
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=+++++++
delete * from transaction where SettlementDate > '3 month';