MONTHNAME(date)SELECT MONTHNAME(‘2016-01-16') SELECT MONTHNAME(‘2016-01-16 00:00:00')-> January (表示返回date的是当年第几月的英文名字)