How to Change Date from dd/mm/yyyy to yyyy-dd-mm in PHP

Table of Contents

Change Date from dd/mm/yyyy to yyyy-dd-mm for MYSQL Friendly is simple.

$date_array = explode("/",$date); // split the array$var_day = $date_array[0]; //day seqment$var_month = $date_array[1]; //month segment$var_year = $date_array[2]; //year segment$new_date_format = "$var_year-$var_day-$var_month"; // join them together

Possibly a more MySQL friendly format in some circumstances and Convert date from YYYY/MM/DD to DD.MM.YYYY (and from DD.MM.YYYY to YYYY/MM/DD)

/** * @param string $date (d.m.y, y-m-d, y/m/d) * @return string|bol */function convertDate($date) {       // EN-Date to GE-Date       if (strstr($date, "-") || strstr($date, "/"))   {               $date = preg_split("/[\/]|[-]+/", $date);               $date = $date[2].".".$date[1].".".$date[0];               return $date;       }       // GE-Date to EN-Date       else if (strstr($date, ".")) {               $date = preg_split("[.]", $date);               $date = $date[2]."-".$date[1]."-".$date[0];               return $date;       }       return false;}