Fetching rows added in the last hour using Laravel 5.1

Question

I am working on a project in which I have to track all the records which are added in last hour of current time.

I am able to do this by using following query,

select count(*) as cnt
from  log
where date >= DATE_SUB(NOW(),INTERVAL 1 HOUR); 

but not able to do the same in Laravel.

Answer 1

You can use the Carbon date time api to get the last hour formated datetime

$count = \DB::table('logs')->where('date', '>=', \Carbon\Carbon::now()->subHour())->count();