除了过去24小时的UNIX时间格式外，如何从数据库中删除数据

Question

I want to delete data from database via corn.

For example: i need to delete my all data except last 24 hour.

My time format is UNIX time Like

1531920800

Answer 1

This should do the trick:

$time = time();
$oneDay = 60 * 60 * 24;
$yesterday = $time - $oneDay;

$sql = 'DELETE FROM tablename WHERE columname < ' . $yesterday;