Home > Backend Development > PHP Tutorial > Questions sorted by time?

Questions sorted by time?

WBOY
Release: 2023-03-01 22:08:01
Original
1194 people have browsed it

A certain time field in the table has some formats:

<code>            November 11, 2016
            31 Oct 2016
            2016-01-11
            07 Nov 2016
            </code>
Copy after login
Copy after login

Can I sort by time?

Reply content:

A certain time field in the table has some formats:

<code>            November 11, 2016
            31 Oct 2016
            2016-01-11
            07 Nov 2016
            </code>
Copy after login
Copy after login

Can I sort by time?

python3

<code class="python">>>> import time
>>> t=[('November 11, 2016','%B %d, %Y'),
       ('31 Oct 2016','%d %b %Y'),
       ('2016-01-11','%Y-%m-%d'),
       ('07 Nov 2016','%d %b %Y'),]
>>> t.sort(key=lambda d:time.mktime(time.strptime(d[0],d[1])))
>>> from pprint import pprint as pp
>>> pp(t)
[('2016-01-11', '%Y-%m-%d'),
 ('31 Oct 2016', '%d %b %Y'),
 ('07 Nov 2016', '%d %b %Y'),
 ('November 11, 2016', '%B %d, %Y')]
>>> </code>
Copy after login

<code>$date = [
    'November 11, 2016',
    '31 Oct 2016',
    '2016-01-11',
    '07 Nov 2016'
];

usort($date, function($a, $b){
    $a = strtotime($a);
    $b = strtotime($b);
    if ($a == $b) {
        return 0;
    }
    return ($a > $b) ? 1 : -1;
});</code>
Copy after login

php

composer install Carbon

<code class="php">use Carbon\Carbon;

$date = [
    new Carbon('November 11, 2016', 'Asia/Shanghai'),
    new Carbon('31 Oct 2016', 'Asia/Shanghai'),
    new Carbon('2016-01-11', 'Asia/Shanghai'),
    new Carbon('07 Nov 2016', 'Asia/Shanghai'),
];

for ($i = 0; $i < count($date); $i++) {
    for ($j = 0; $j < $i; $j++) {
        if ($date[$j]->lt($date[$i]) {
            $tmp = $date[$j];
            $date[$j] = $date[$i];
            $date[$i] = $tmp;
        }
    }
}</code>
Copy after login

Call on mobile phone...Sorry if there is any mistake...

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template