Date picker date format not changing2 users found helpful
But in the mysql is not matched format. So, It is not storing the date.
I changed date format in jquery.ui.js. But Its just showing the in the same pattern.'
I need to change this format in to yy/mm/dd.
Please show me some way to retrieve from this problem...'Thanks in advance...
So when saving from a form field that you set with the date picker, you need to translate the format from whatever the c5 front end format for the datepicker is (set by locale) into the mySQL format.
Then when retrieving, do the reverse.
There is a date helper for this which takes locale into account. There are also standard php functions that do such a translation.
Could you mention the what php file contains this set locale...
When I select date from datepicker, it shows in the text box in mm/dd/yy format.
So, during the inser data into database, date saved as 0000-00-00.
It's Works... ;-)
Exactly this is what i need...