日期取年、月、日select year(time),month(time), DAY(time),TIME(time) from user where phone='xx'#分别取年、月、日、时间select year(time) from user where phone='xxxxxx'#取年select month(time) from user where phone='xxxxxx' #