I am using datepicker in my form for booking date field. when i pick a date it shown like this 11/13/2013 (MM/DD/YYYY). In mysql database i am using datetime Type. in mysql db always shows 0000-00-00 00:00:00. i want to change the date format. for example if i am choose today date like this (11/13/2013) it should stored in mysql db like this (13-11-2013) with current time. how to change the date format permanently in mysql? i know NOW() stored the current time in mysql. but how can i integrate with datepicker??