Originally Posted by UnifiedStats_John

to view the data:
select * from tablename where datetime < DATE_ADD(now(), interval -15 day) order by datetime;

and if it looks right, to delete:
delete from tablename where datetime < DATE_ADD(now(), interval -15 day);