google spreadsheet date format dd/mm/yyyy to yyyy/mm/dd formula code example

Example 1: SQL query to convert DD/MM/YYYY to YYYY-MM-DD

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

Example 2: php convert date from dd/mm/yyyy to yyyy-mm-dd

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