php date conversion

[spoilchile]

I have a javascript calendar that outputs a date but the format (dd/mm/yy) is not accepted by MySQL. Is there anyway I can change the output to an acceptable format without changing the javascript?

[igorlopez]

If you have php between the javascript and MySQL it is easy to convert the string from the javascript: '(DD/MM/YY)' to a 'YYMMDD' format accepted in a DateTime field in MySQL using

$dateArray = explode('/', substr($javaDate, 1, -1));
$mySqlDate = $dateArray[2].$dateArray[1].$dateArray[0];

$javaDate is the string from the javascript, substr to get rid of the parenthesises and explode to extract the different date fields into an array. The resulting $mySqlDate can then be inserted into the database.

[spoilchile]

Thanks for the assistance but it isnt working. The javascript string is outputting the date format as dd/mm/yy e.g. 5/11/2008. What i wanted was to change this string into 2008/11/5. Could this be done? If so could you show me how?

Thanks

[igorlopez]

Ok, if the string does not have any parenthesis around and you really want the slashes in the result

$dateArray = explode('/', $javaDate);
$mySqlDate = $dateArray[2] . '/' . $dateArray[1] . '/' . $dateArray[0]; 

If this does not work you have to show us what you have and what your result is.

[spoilchile]

Thanks I got it to work