两个日期之间的小时数差异

Question

I'm in doubt about a question that I do in CakePHP. I need to get all the records from my database depending on the difference in hours with a rough date. for instance :

$date = 2015-10-15 11:10:59;

I need calculate that between $data['Inscripcion']['date'] and $date have four or more hours apart, otherwise should not bring records database. All this in find->('list', array('conditions => array('date'))).

but it can not think of me as to include the value of the data within the same query

Answer 1

Not sure exactly what you're trying to do, but

if (abs(strtotime($date) - strtotime($data['Inscripcion']['date'])) > (60 * 60 * 4)) {
  // stuff 
}

Edit: Sorry, I'm used to PHP 5.3, see nessuno's answer.