format to yyyy-mm-dd in mysql code example
Example: convert dd/mm/yyyy to yyyy-mm-dd in mysql php
$var = '20/04/2012';
$date = str_replace('/', '-', $var);
echo date('Y-m-d', strtotime($date));
$var = '20/04/2012';
$date = str_replace('/', '-', $var);
echo date('Y-m-d', strtotime($date));