mysql获取年份，月份，天数，的时间函数！

1、获取年份

    select YEAR(CURDATE());
    2018

2、获取月份

select MONTH(CURDATE());
12

3、获取日期

select DATE(CURDATE());
14

4、获取当年一月份

select CONCAT(YEAR(CURDATE()),'-','01');
2018-01

总结：
其实前3个函数的用法就是MONTH(时间)，例如：

select MONTH('2018-05-08')
5

例如：

select avg(flow) flow,avg(talk) talk,avg(cost) cost from bill where 
MONTH(CURDATE()) - MONTH(b_time) < 5 
and uid = (select uid from user where phone = 13277924031)