Originally Posted by Old Pedant
The reason I ask: If the value from the datapicker is in the format "mm/dd/yyyy" or "dd/mm/yyyy" then it won't work with MySQL. MySQL requires format "yyyy-mm-dd". So you need to either re-format the date in your PHP code or use a MySQL function that will convert from the wrong format to the right one.
yes, My Datetimepicker format is mm/dd/yy from jquery ui site
and my mysql date format is yyyy-mm-dd so, i can't insert
So,How to reformat the date or how to change sql format