1、获取年份
select YEAR(CURDATE());
2018
2、获取月份
select MONTH(CURDATE());
4
3、获取日期
select DATE(CURDATE());
2018-04-22
4、获取当年一月份
select CONCAT(YEAR(CURDATE()),'-','01');
2018-01
1、获取年份
select YEAR(CURDATE());
2018
2、获取月份
select MONTH(CURDATE());
4
3、获取日期
select DATE(CURDATE());
2018-04-22
4、获取当年一月份
select CONCAT(YEAR(CURDATE()),'-','01');
2018-01