Error after Update into database from Calendar input


I am using Calendar for updating information from database, when I try to update it goes like this:update ticket set DATAT=‘Tue Jan 20 2015 00:00:00 GMT+0200 (EET)’ WHERE ID = ‘1092’ how I can control the data which send for update, to have the possibility to change the format or how I should config to can to the update for date type of data in MySQL.


How do you retrieve date from calendar?

I use :

var dpg = new dataProcessor("${pageContext.request.contextPath}/grid/"); //inits dataProcessor
dpg.init(contactsGrid); //associates the dataProcessor instance with the grid
dpg.attachEvent(“onAfterUpdate”, function (sid, action, tid, tag) {
if (action == “inserted”) {
contactsGrid.selectRowById(tid); //selects a row
contactForm.setFocusOnFirstActive(); //sets focus to the 1st form’s input

            contactForm.attachEvent("onButtonClick", function (id) {                     //attaches a handler function to the "onButtonClick" event
      ;                                                    //sends the values of the updated row to the server

for input code is used:

I tried this contactForm.setCalendarDateFormat(“DATAT”, “%d/%m/%y”, “%Y-%m-%d”);
but it is not working.

Please, provide us completed demo on with a link to this topic … pport.html