Change Date from dd/mm/yyyy to yyyy-dd-mm

Submitted by:Jhon Smith

Date added:18 February, 2011


Change Date from dd/mm/yyyy to yyyy-dd-mm

Tags: change date , change data format , change php data format

Code Snippet:

$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. Change period-separated to slash-separated or vice versa (and reverse order) 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;