STR_TO_DATE(date,format ):將字串轉換成format格式的日期時間SELECT STR_TO_DATE(‘2015-01-01', ‘%Y-%m-%d')-> 2015-01-01