STR_TO_DATE(date,format ):将字符串转成format格式的日期时间SELECT STR_TO_DATE(‘2015-01-01', ‘%Y-%m-%d')-> 2015-01-01