将日期时间2016-05-13 16:07:50转化为字符串20160513
date_format
select phone, date_format(time, '%Y%m%d%H%i%s') from user where phone='xxxxxxxx' #20160513160750
select phone, date_format(time, '%Y%m%d') from user where phone='xxxxxxxx' #20160513