Convert date in format MM/DD/YYYY to MySQL date [duplicate]

Question

I have a PHP function that gets passed a date in the format MM/DD/YYYY I need to then convert this so that it can be added to a MySQL field that is of type date

How would I go about doing this in PHP?

Answer 1

$newvalue = date('Y-m-d', strtotime($originalvalue));

Answer 2

MySQL displays the DATE type as 'YYYY-MM-DD', so you could do something like:

date("Y-m-d",strtotime("10/18/2013"));

Answer 3

My variant:

  $mysql_date = date('Y-m-d', strtotime(str_replace('/','-', $value)));