mysql 获取今年第一天
SELECT DATE_SUB(CURDATE(),INTERVAL dayofyear(now())-1 DAY)
结果:
mysql 获取去年第一天
select DATE_SUB(DATE_SUB(CURDATE(),INTERVAL dayofyear(now())+1 DAY),INTERVAL dayofyear(DATE_SUB(CURDATE(),INTERVAL dayofyear(now())+1 DAY))-1 DAY);
-- 第二种
SELECT CONCAT(year(DATE_SUB(CURDATE(), INTERVAL 1 YEAR)),"-01-01")
结果:
1.
2.