PHP

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));

yyyymmdd to yyyy-mm-dd php

<?php
// both lines output 813470400
echo strtotime("19951012"), "
",
     strtotime("12 October 1995");

// prints 1995 Oct 12
echo date("Y-m-d", strtotime("19951012"));
?>