Why such SQL condition deletes data?

Question

MySQL

DELETE FROM `table` WHERE `label` < (CURDATE()-15)
I was hoping that it would delete records older than 15 days, but in fact, on the 1st, it deletes all data for the previous month, i.e. even for yesterday.

Answer 1

Such a condition is incorrect.
For time range manipulation use DATE_SUB/DATE_ADD

DELETE FROM `table` WHERE `label` < DATE_SUB(CURDATE(), INTERVAL 15 DAY)