all above does not work for me.

DELETE FROM report_viewed_product_index WHERE DATE(added_at) < CURDATE();

deletes only the last 6 hours of yesterday

DELETE FROM report_viewed_product_index WHERE DATE(added_at) < NOW() - INTERVAL 10 DAY;

delets nothing

SELECT DATE(NOW() - INTERVAL 11 DAY) gives "2025-01-10"

is tehre aproblem with thebtimestamps or the UTC timeshift?

screenshot of my DB