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