There are some formats for a Time field in the table:
November 11, 2016 31 Oct 2016 2016-01-11 07 Nov 2016
Can I sort by time?
Reply content:
There are some formats for a Time field in the table:
November 11, 2016 31 Oct 2016 2016-01-11 07 Nov 2016
Can I sort by time?
Python3
>>> import time>>> t=[('November 11, 2016','%B %d, %Y'), ('31 Oct 2016','%d %b %Y'), ('2016-01-11','%Y-%m-%d'),
$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;});
Php
composer install Carbon
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; } }}
The phone is playing ... If there is a mistake, forgive me ...