How to delete rows with timestamp older than 7 days

Question

My timestamp format looks like this: 2014-02-27 08:54:53

The table is product_views, and the time field is ViewStamp. I don't know how to DELETE rows older than 7 days.

$query="DELETE FROM product_views WHERE ViewStamp< ?";

Thanks for the help. I am still a beginner so if I did not provide enough info please let me know and I will edit.

edit: Using MySQL

possible duplicate of [Delete all rows with timestamp older than x days](http://stackoverflow.com/questions/21206361/delete-all-rows-with-timestamp-older-than-x-days) — aksu, Feb 27 '14 at 15:19

score 1 · Answer 1 · answered Feb 27 '14 at 15:14

1

DELETE FROM product_views WHERE ViewStamp < DATE_SUB(?, INTERVAL 7 DAYS)

If you just want from "now" instead of passing a timestamp as a parameter, you can replace the ? with the SQL function NOW().

answered Feb 27 '14 at 15:14

Zebra North

score 1 · Answer 2 · answered Feb 27 '14 at 15:14

1

Try like:

DELETE FROM product_views WHERE ViewStamp < (NOW() - INTERVAL 7 DAY)

answered Feb 27 '14 at 15:14

aksu

score 0 · Answer 3 · answered Feb 27 '14 at 15:16

0

$query = "DELETE FROM product_views WHERE ViewStamp < now() - interval 7 day";

answered Feb 27 '14 at 15:16

thomas.mc.work

score 0 · Answer 4 · answered Feb 27 '14 at 15:18

0

Using the date_add function you can do this. Assuming that you are using MySQL

DELETE FROM product_views WHERE ViewStamp < DATE_ADD(NOW(),INTERVAL -7 DAY)

answered Feb 27 '14 at 15:18

Simon Blok

4 Answers4