delete old timestamp

[jagguy]

I want to delete all timstamp entried older than 2 days.

 

This fails to delete do anything and there is no error.

The field name is date and table name is logbook

 

$sql="Delete from logbook where TIMESTAMPDIFF(DAY, 'date', NOW()) > 2 " ;

[hitman6003]

DELETE FROM logbook WHERE date < DATE_SUB(NOW(), INTERVAL 2 DAY);

[clearstatcache]

try ds...

 

DELETE FROM logbook WHERE unix_timestamp(date) <  (unix_timestamp(current_timestamp()) - 172800);

[jagguy]

This works on my mysql DB

 

Delete from logbook  where TIMESTAMPDIFF(SQL_TSI_DAY, date, NOW()) > 2