How to sort array by datatime values

Question

i have array like this:

Array
(
    [4] => Array
        (
            [dep] => 23:24
            [seconds] => 84240
            [date] => 2014-05-15 23:24:00
        )

    [3] => Array
        (
            [dep] => 04:49
            [seconds] => 17340
            [date] => 2014-05-16 04:49:00
        )

    [2] => Array
        (
            [dep] => 04:22
            [seconds] => 15720
            [date] => 2014-05-16 04:22:00
        )

    [1] => Array
        (
            [dep] => 04:07
            [seconds] => 14820
            [date] => 2014-05-16 04:07:00
        )

    [0] => Array
        (
            [dep] => 00:04
            [seconds] => 240
            [date] => 2014-05-16 00:04:00
        )

)

I would like sort and get something like: 1. 2014-05-15 23:24:00

2014-05-16 00:04:00
2014-05-16 04:07:00
2014-05-16 04:22:00
2014-05-16 04:49:00

Thanks for replay ;)

http://stackoverflow.com/questions/8121241/sort-array-based-on-the-datetime-in-php — Abhik Chakraborty, Mar 31 '14 at 11:52

score 0 · Answer 1 · answered Mar 31 '14 at 11:51

0

How about translating the values into unix time and sorting by that?

answered Mar 31 '14 at 11:51

Tom Teman

1,975
3
28
43

//your array with details $datatimearray; $tmparray = array() foreach($datatimearray as $key => $val) { $settime = strtotime($val); } ksort($tmparray); $datatimearray = $tmparray; print_r($datatimearray); – Harsh Chunara Mar 31 '14 at 12:49

score 0 · Answer 2 · answered Mar 31 '14 at 11:52

0

Thats probably the easiest solution:

sort(strtotime($array['date']));

answered Mar 31 '14 at 11:52

Realitätsverlust

3,941
2
22
46

`sort(strtotime($array['date']))` will that work? – Lepanto Mar 31 '14 at 11:58
It converts all the dates to timestamps and sorts them. It should work. Of course, you have to adjust the name of the array according to your arrayname. – Realitätsverlust Mar 31 '14 at 12:04
had that question since the array is multi-dimensional – Lepanto Mar 31 '14 at 12:07

score 0 · Answer 3 · answered Mar 31 '14 at 11:52

0

Use strtotime on each of those fields and then sort them with asort.

answered Mar 31 '14 at 11:52

Uriziel

177
1
10

How to sort array by datatime values

3 Answers3