[josepichu]

Hi!,

How can I Show the last 24h records?

I know with standard SQL:

SELECT  *

FROM    mytable

WHERE   record_date >= SYSDATE() - INTERVAL 1 DAY

I have tried using the where() method, as it says in the userguide, but it doesn't show any records:

$array = array("date>=" => "SYSDATE() - INTERVAL 1 DAY");

$this->grocery_crud->where($array);

Thanks!