Code Snippet
Change Date from dd/mm/yyyy to yyyy-dd-mm
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.
DigWP
A book and blog co-authored by Jeff Starr and myself about the World's most popular publishing platform.
Quotes on Design
Design, like Art, can be an elusive word to define and an awfully fun thing to have opinions about.
HTML-Ipsum
One-click copy to clipboard access to Lorem Ipsum text that comes wrapped in a variety of HTML.
Bookshelf
Hey Chris, what books do you recommend? These, young fertile mind, these.