sql语句使acard_date字段大于上个月并且小于本月
SELECT * FROM table_name WHERE a.card_date > DATEADD(month, DATEDIFF(month, 0, GETDATE())-1, 0) AND a.card_date < DATEADD(month, DATEDIFF(month, 0, GETDATE()), 0)
原文地址: https://www.cveoy.top/t/topic/bnz5 著作权归作者所有。请勿转载和采集!