select DATE_SUB(DATE_SUB(CURDATE(),INTERVAL dayofyear(now())+1 DAY),INTERVAL dayofyear(DATE_SUB(CURDATE()
MySql 获取去年的第一天
最新推荐文章于 2023-02-21 19:56:08 发布
![](https://img-home.csdnimg.cn/images/20240611030827.png)
select DATE_SUB(DATE_SUB(CURDATE(),INTERVAL dayofyear(now())+1 DAY),INTERVAL dayofyear(DATE_SUB(CURDATE()