Getting wrong result after sorting datetime array in PHP

Question

I want to sort an array by datetime in decending order. Here is the example array:

<?php
$var1 = "2016-12-30 12:30:59";
$var2 = "2015-11-21 11:30:59";
$var3 = "2017-01-15 10:30:59";

$a = array($var1, $var2, $var3);

function compare_func($a, $b) {
    // CONVERT $a AND $b to DATE AND TIME using strtotime() function
    $t1 = strtotime($a[0]);
    $t2 = strtotime($a[1]);

    return ($t2 - $t1);
}

usort($a, "compare_func");

var_export($a);
?>

The output I am getting is:

array (
  0 => '2017-01-15 10:30:59',
  1 => '2015-11-21 11:30:59',
  2 => '2016-12-30 12:30:59',
)

LF-DevJourney · Accepted Answer · 2017-01-18 06:30:52Z

2

You can compare the string directly.

function compare_func($a, $b) {
    return ($a > $b);
}

edited Jan 18, 2017 at 6:30

answered Jan 18, 2017 at 6:29

LF-DevJourney

28.6k30 gold badges170 silver badges321 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

NID · Accepted Answer · 2017-01-18 06:52:55Z

0

Try this:

<?php
$var1 = "2016-12-30 12:30:59";
$var2 = "2015-11-21 11:30:59";
$var3 = "2017-01-15 10:30:59";

$arr = array($var1, $var2, $var3);

function date_sort($a, $b) {
    return strtotime($b) - strtotime($a);
}
usort($arr, "date_sort");
print_r($arr)


?>

OUTPUT in decending order

Array
(
    [0] => 2017-01-15 10:30:59
    [1] => 2016-12-30 12:30:59
    [2] => 2015-11-21 11:30:59
)

answered Jan 18, 2017 at 6:52

NID

3,3241 gold badge21 silver badges29 bronze badges

Collectives™ on Stack Overflow

Getting wrong result after sorting datetime array in PHP

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related