SQL query to convert DD/MM/YYYY to YYYY-MM-DD

$date = DateTime::createFromFormat('d/m/Y', "24/04/2012");
echo $date->format('Y-m-d');

SELECT CONVERT(varchar(10), CONVERT(date, '13/12/2016', 103), 120)