PHP: Parse from an array the oldest date

Question

I have this array:

array(2) { 
    [0]=> array(2) {
        ["url"]=> string(104) "aHR0cDovL3lvdXR1YmUuY29t"
        ["date"]=> string(19) "2014-01-06 21:44:39" 
     }

    [1]=> array(2) { 
        ["url"]=> string(28) "aHR0cDovL3d3dy5nb29nbGUuY29t"
        ["date"]=> string(19) "2014-01-06 14:28:32"
     }
 }

How can I parse the $row['date'] for the earliest date?

possible duplicate of How to find the maximum and minimum date by key — M Khalid Junaid
– M Khalid Junaid, Commented Jan 6, 2014 at 20:32
Are you getting this array from a database? You can change up the query (ORDER BY date ASC if you're in MySQL) to automatically give you sorted results, oldest date first. — Esaevian
– Esaevian, Commented Jan 6, 2014 at 20:33

sergio · Accepted Answer · 2014-01-06 20:33:57Z

9

I think you can do this using array_map and min functions:

function customFunction($array) {
  return $array['date'];
}
$dateArray= array_map('customFunction', $array);

So, you have an array with your dates, after just do:

$oldDate = min($dateArray); //here you get the oldest date

answered Jan 6, 2014 at 20:33

sergio

5,2607 gold badges27 silver badges47 bronze badges

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

3 Comments

jQuerybeast Over a year ago

Thank you. This work perfectly. Is it possible I can make minus 1 second from the $oldate?

sergio Over a year ago

Yes, look here: stackoverflow.com/questions/12885098/…, hope it help you

user555 Over a year ago

@jQuerybeast I think DateTime::sub should do the trick.

tuffkid · Accepted Answer · 2014-01-06 20:38:51Z

5

To find the min date in array try this code

 $minDate = min(array_map(function($item) { return $item['date']; }, $array));

answered Jan 6, 2014 at 20:38

tuffkid

1,3239 silver badges8 bronze badges

3 Comments

jQuerybeast Over a year ago

How can I make this minus 1 second?

tuffkid Over a year ago

echo date("Y-m-d H:i:s", strtotime($minDate) - 1)

Ryan Over a year ago

If nulls are messing up your min(), see stackoverflow.com/a/23565246/470749

Sam · Accepted Answer · 2014-01-06 20:34:23Z

1

Something simple like this should do

$earliest_date = date_create();
foreach($rows as $row) {
    $date = date_create($row['date']);
    if($date < $earliest_date)
        $earliest_date = $date;
}

answered Jan 6, 2014 at 20:34

Sam

20.5k2 gold badges48 silver badges71 bronze badges

Collectives™ on Stack Overflow

PHP: Parse from an array the oldest date

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related