MySQL日期格式化JavaScript

Question

Have post input via a JavaScript date-picker which is assigned to a variable producing a result like 2015-01-11.

Looking to insert into date field on MySQL. I have tried many combination STR_TO_DATE($date_field,'%Y-%m-%d) and date('Y-m-d h:i:s',strtotime(sanatize($_POST['date_field']))).

Answer 1

You need quotes around the date value in MySQL:

STR_TO_DATE('$date_field', '%Y-%m-%d')

Otherwise, it will treat 2015-01-11 as subtraction of numbers.