1:查询年月日
select year(now());
select month(now());
select day(now());
2:查询前一天日期
SELECT day(DATE_SUB(CURDATE(),INTERVAL 1 DAY));
select year(now());
select month(now());
select day(now());
2:查询前一天日期
SELECT day(DATE_SUB(CURDATE(),INTERVAL 1 DAY));