将日期时间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本文共 232 字，大约阅读时间需要 1 分钟。
将日期时间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转载地址：http://bkcix.baihongyu.com/