1.用STR_TO_DATE(str,format)函数将字符串格式化:
例1:STR_TO_DATE('2017-02-08 22:23:34','%Y%m%d') ----------->out 为2017-02-08;
例2:STR_TO_DATE('08,02,2018','%d,%m,%Y') ----------->out 为2017-02-08;
例3:STR_TO_DATE('Feb 08, 2017','%M %d,%Y') ------------>out 为2017-02-08;
例4:STR_TO_DATE('02/08/2017', '%m/%d/%Y') ------------>out 为2017-02-08;