Treehouse: Grow your CSS skills. Land your dream job.

Last updated on:

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


$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;


  1. kukat
    Permalink to comment#

    date(‘Y-m-d’, strtotime(’23/10/2009′));

  2. Fabricio Anzorena
    Permalink to comment#

    implode(‘-‘, array_reverse(explode(‘/’,$date)));

    Won’t have the 1970 limit problem of the timestamp.

  3. Emma Davis
    Permalink to comment#

    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”;

  4. Prashant Palikhe
    Permalink to comment#

    Fabricio’s answer is much more elegant and works just fine:)

  5. nile
    Permalink to comment#

    kukat’s is the best though.

  6. Kira
    Permalink to comment#

    Thank you. Simply effective :)

  7. Jitendra Joshi
    Permalink to comment#

    DateTime::createFromFormat(‘d/m/Y’, “21/1/2013″)->format(“Y-m-d”)

  8. Olivier C
    Permalink to comment#

    * @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 ”;

Leave a Comment

Posting Code

We highly encourage you to post problematic HTML/CSS/JavaScript over on CodePen and include the link in your post. It's much easier to see, understand, and help with when you do that.

Markdown is supported, so you can write inline code like `<div>this</div>` or multiline blocks of code in in triple backtick fences like this:

  function example() {
    element.innerHTML = "<div>code</div>";