Conversion
$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;
}
date(‘Y-m-d’, strtotime(’23/10/2009′));
implode(‘-‘, array_reverse(explode(‘/’,$date)));
Won’t have the 1970 limit problem of the timestamp.
Your last line of code in preparing the date for databse is incorrect as it puts the day before the month:
$new_date_format = “$var_year-$var_day-$var_month”;
Should be:
$new_date_format = “$var_year-$var_month-$var_day”;
Fabricio’s answer is much more elegant and works just fine:)
kukat’s is the best though.
Thank you. Simply effective :)
DateTime::createFromFormat(‘d/m/Y’, “21/1/2013”)->format(“Y-m-d”)
/**
* @name Date Change Format
* @note PHP > 5.3
* @params date, from date format, to date format
* @use date_change_format()
*/
function date_change_format($setDate, $from=’Y-m-d’, $to=’d/m/Y’) {
if($setDate !=”) {
$date = DateTime::createFromFormat($from, $setDate);
return $date->format($to);
} else {
return ”;
}
}
To me the fastest solution is to use the strtr function:
To translate from dd/mm/yyyy to yyyy-dd-mm:
strtr(‘Y123-Dd-Mm’, ‘Dd.Mm.Y123′, ’27/11/2017’);