Kid>做个笔记 MySql 查看12天内失效日期的药品 select COUNT(*) from warehouse where expirydate between NOW() and DATE_SUB(CURDATE(),interval -12 day) 解释:DATE_SUB():mysql函数 select NOW() 2021-03-16 14:45:04 select CURDATE() 2021-03-16