我需要得到日期按日期过滤器:过去10天,过去30天,过去12个月。我对它进行了编码:SELECT * FROM INVOICES WHERE invoices.date>= DATE_ADD(CURDATE(),INTERVAL -10 DAY);SELECT * FROM INVOICES WHERE invoices.date>= DATE_ADD(CURDATE(),INTERVAL -30 DAY);SELECT * FROM INVOICES WHERE invoices.date>= DATE_AD