saving date to mysql problem

2009-11-12 Thread jiru
hii, echo $form-input('issue_date',array('type'= 'text','id'= 'datepick')); this is my issue date input field in add.ctp. I'm displaying the default(current)date using jquery. It showing like 11/12/2009 in text field. In my MySql db the field is -- 'issue_date DATE'. After saving the data in

Re: saving date to mysql problem

2009-11-12 Thread jiru
Thank you.. On Nov 12, 3:13 pm, Aurimas a.lic...@gmail.com wrote: Change date format 11/12/2009 to 2009-12-11 in your datepicker or change format before saving. MySQL displays DATE values in ‘-MM-DD’ format On Nov 12, 12:08 pm, jiru jiransl...@gmail.com wrote: hii, echo

Re: saving date to mysql problem

2009-11-12 Thread Aurimas
Change date format 11/12/2009 to 2009-12-11 in your datepicker or change format before saving. MySQL displays DATE values in ‘-MM-DD’ format On Nov 12, 12:08 pm, jiru jiransl...@gmail.com wrote: hii, echo $form-input('issue_date',array('type'= 'text','id'= 'datepick')); this is my issue